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
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 Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
It is IPV4 addressing.
Mark
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks