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!

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]
42 comments
-
Aaron Ricci commented
Please!!!
-
Michael Daughety commented
Add IPv6 to this request as well!
-
Mark commented
Please this is much needed.
-
Jeremy Murray commented
Great Idea
-
Terry Tusher commented
Why isn't this already done MS! Throw us a bone here.
-
Mark commented
Yes, please. The ability to sort correctly would be MUCH appreciated too.
-
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.