Forum Discussion
Excel - Expand IP address range to individual IP ?
I have a set of data like this in Ms Excel
10.0.0.1-10.0.0.3
172.16.0.3
192.168.0.2-192.168.0.2
How do I expand those IP Address and produce an output like this?
10.0.0.1
10.0.0.2
10.0.0.3
172.16.0.3
192.168.0.2
1 Reply
Do you only have entries where number after the last dot changes, such as
10.0.0.1-10.0.0.3
Or could numbers before that change to, such as
10.0.0.128-10.0.2.255
or even
10.0.0.0-10.1.8.127
