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
Bookmarks