I have a situation where I have ten's of thousands of IP Addresses (the Network portion) and the Subnet Mask. I need to somehow create another field in Excel 2007 that will show the IP Address Range based on the two fields.
Example:
IP Address Network: 10.15.32.0
Subnet Mask: 255.255.255.248
DESIRED OUTCOME: 10.15.32.1 to 10.15.32.6
Bookmarks