Excel IP address and subnet to network and inverse mask [closed]
- by Steve Dailey
We need a script, marco or something in excel where we can take list like below
interface Vlan100
ip address 192.168.1.3 255.255.255.0
interface Vlan101
ip address 192.168.2.3 255.255.255.128
interface Vlan102
ip address 192.168.2.130 255.255.255.128
interface Vlan103
ip address 192.168.3.3 255.255.255.240
etc...
and produce a list like below
ospf 1
undo silent-interface Vlan-interface100
undo silent-interface Vlan-interface101
undo silent-interface Vlan-interface102
undo silent-interface Vlan-interface103
area 0.0.0.0
network 192.168.1.0 0.0.0.255
network 192.168.2.0 0.0.0.127
network 192.168.2.128 0.0.0.127
network 192.168.3.0 0.0.0.15
so it will need to take an ip address/subnet mask and convert them to network number/inverse mask. I believe I can handle the Vlan manipulation with a substitution so no need to spend time on that.