Hi there. New to the forum and I have looked at length for a solution. I think there are lots here, but they are either old of they dont really say clearly enough how to use them. I'm no Excel expert so just receiving some VB code or even 'here is a function' would need some help explaining. I have two lists. One contains subnet mask and subnet address so
Subnet Address Subnet Mark I need CIDR here
1.1.1.0 255.255.255.0
The other has CIDR
CIDR I need subnet address here I need Subnet mask here
1.1.1.0/24
I think I can live with just the conversion of subnet address and mask to CIDR, but it would be nice to have both.
Subnets could be class A,B,C or D
Bookmarks