Feedback by UserVoice

 

How can we improve Excel for Windows (Desktop Application)?

← Excel for Windows (Desktop Application)

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!

307 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Alex Chard shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded  · 

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

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Mark commented  ·   ·  Flag as inappropriate

    Yes, please. The ability to sort correctly would be MUCH appreciated too.

  • Evgeny commented  ·   ·  Flag as inappropriate

    All was already said in this thread. I just fully support other folks.
    Good luck!

  • Jim commented  ·   ·  Flag as inappropriate

    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.

  • NickL commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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 ! ! ! ! !

  • queen__frostine commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

← Previous 1 3

Excel for Windows (Desktop Application): Formulas and Functions

Categories

Feedback and Knowledge Base

(thinking…)