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....
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