IP Address as a datatype.
I would love to see IP Addresses added as a format option and functions added for validation of the IP addresses..
For instance InSubnet(Network as IP,Netmask as Integer,address as IP) to determine if an IP is within a Subnet;
Being able to do addition/subtraction on the field would be awesome as well!
Alex Chard
shared this idea
Thanks for the suggestion Alex, and thanks to those that making their vote heard. This is a pretty interesting ask – take a look at the comment I made. I’d like us to understand a few related things. And as always, please keep voting for the things you care about most.
Cheers,
John [MS XL]
36 comments
-
mike westkamper
commented
I posted here years ago, and IP addresses as a datatype still isn't something M$ will do. I did find this however:
https://github.com/andreafortuna-org/VBAIPFunctions
They work and are quite useful.
-
Evgeny
commented
All was already said in this thread. I just fully support other folks.
Good luck! -
Jim
commented
This would be soooooo useful! I spend hours of my day maintaining spreadsheets of ipv4 addresses. Just to be able to sort them correctly would be huge.
-
Alan Bolster
commented
Please make this happen!
-
Bin
commented
100% Yes, please!
So much time saved. -
NickL
commented
YES!! If I could put in a subnet in CIDR notation, and be able to autofill... OMG, do you have any idea how much time that would save me!!?? Meaning... if I type in something like 192.168.1.0/26, and then autofill down, it would fill in 192.168.1.64/26 in the next cell, 192.168.1.128/26 in the following, and so on. That would make the daunting task of planning and documenting your network so much easier!
-
Joe Poole
commented
In this day and age, everything is connected and has an IP Address. IT staff everywhere could use IP Address formats and functions. I am surprised we have to ask for this ability. You would think a technology giant like Microsoft would be just a little bit more in tune with IT needs.
-
Bill Haughton commented
I absolutely support IP-V4 address support, and within a year after, IP.V6 support.
It's amazed me that IP.V4 addressing has not been included thus far. Granted, it may be a somewhat selective audience, but a critical one, that keeps your networks running ! ! ! ! !
-
Rob Clive
commented
This would be handy
-
queen__frostine
commented
Yes to more data types!!!!!!! I'm sure the consumer goods industry would love you forever if UPCs/GTINs were also a data type.
-
Anonymous
commented
In format cells, you could try using "000.000.000.000,,," as an option. It's not perfect, but works fine if all the octets are with 3 numbers (192.168.128.100).
-
Jaime Castells
commented
The ability to sort by IP and/or subnet in CIDR notation as well as perform logical tests between IP values, IP and CIDR or multiple CIDRs would be a relief. I have a number of hoops I keep at hand so I can jump through them. It's time consuming and the results are rarely more than passable.
PLEASE add my vote to this list.
-
Łukasz Rutkowski commented
YES YES YES! AND BE ABLE TO SORT IT Ascending and Descending! That would be AWESOME!
-
Steve May
commented
I would too.
-
Eric Fetty
commented
Other data types to maybe consider:
Hexadecimal
Binary
IP Address
MAC Address -
Anonymous
commented
PLEASE ADD IP SUPPORT WE ASK THIS ALREADY FOR YEAAAAARS
-
Grimthaw
commented
Operations/Functions on IP/Mac Addresses would be good:
* Off the top of my head for IPs
** Convert from Dotted Decimal to Dotted Binary
** Split into network and host portions of address
** Perform binary operations on dotted decimal addresses to create:
*** network plans
*** routing summarization tables,
*** network addresses,
*** host addresses
*** broadcast addresses
* Off the top of my head for MACS like IPs
** Split into OUS and NIC portions -
mike westkamper
commented
I never got a comment, so I doubt this is monitored anymore. I suspect that MS resources are not in the Office products anymore. Not much has changed in the last few versions.
I wrote a vb script that parses and does the math and converts the dotted notation in ibv4 to an integer and back to dotted notation. This allows me to sort and convert a number from/to a IPV4 notation. I am not a Excel VB script guru but in my specific instance it does what I need. Some really skilled in vb scripting could add a bunch of features and ipv6 too. The functions are pretty easy to code in Basic.
Good Luck KEn. -
KEn
commented
It's 2016, this has been an issue since the beginning. I am surprised it hasn't been addressed already. I would be happy if I could get the IP cell format to work correctly. Having it tell me if it's part of the same subnet is gravy.
-
mike westkamper
commented
I think this was in here a year or so ago, couldn't find it. I don't see it in Excel. Is it something that is being considered?
Sure would be helpful to able to manipulate, sort, validate, etc IPv4 and IPv6 addresses. Same general features as Date datatype.