I have an Excel spreadsheet containing IP addresses and subnet masks. I need to derive the subnet of each IP address in the spreadsheet.Example: IP (column A): 10.1.230.84, Subnet Mask (column B ...

I think you're confusing subnet with subnet mask. <BR><BR>If you have hard coded your address to something in the 1.0.0.0 range, (which it looks like you have), and the opposite end of the link is ...