+ Reply to Thread
Results 1 to 3 of 3

Need to take an IP Subnet Range and Output Subnet Mask

  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    MI
    MS-Off Ver
    Excel 2013
    Posts
    2

    Need to take an IP Subnet Range and Output Subnet Mask

    Hello All, thanks in advanced for any help!

    I have a spreadsheet with two columns as follows:

    ColumnA ColumnB
    Start IP End IP
    192.168.1.1 192.168.2.255
    10.10.1.1 10.20.255.255

    What I need to do (if possible) is have Excel output the subnet mask in either dotted format (255.255.255.0) or bits (24) and place it in say ColumnC. Is this possible to do with Excel? I have thousands of IP Ranges that I also need the Mask and really dont want to do this manually.

    Thanks again!

    Mark

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,255

    Re: Need to take an IP Subnet Range and Output Subnet Mask

    Hello Markh7999,

    Welcome to the Forum!

    It would help to know if this for IPV4 or IPV6. My feeling is this is for IPV4. IPV6 is new and not as widely used as IPV4, but thought it best to check.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    06-12-2013
    Location
    MI
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Need to take an IP Subnet Range and Output Subnet Mask

    It is IPV4 addressing.

    Mark

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1