Excel - Expand IP address range to individual IP ?

%3CLINGO-SUB%20id%3D%22lingo-sub-1800319%22%20slang%3D%22en-US%22%3EExcel%20-%20Expand%20IP%20address%20range%20to%20individual%20IP%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1800319%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20set%20of%20data%20like%20this%20in%20Ms%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E10.0.0.1-10.0.0.3%3CBR%20%2F%3E172.16.0.3%3CBR%20%2F%3E192.168.0.2-192.168.0.2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20expand%20those%20IP%20Address%20and%20produce%20an%20output%20like%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E10.0.0.1%3CBR%20%2F%3E10.0.0.2%3CBR%20%2F%3E10.0.0.3%3CBR%20%2F%3E172.16.0.3%3CBR%20%2F%3E192.168.0.2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22iNZyC%22%20style%3D%22width%3A%20415px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F228064i9C6E2296D57E8AE9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22iNZyC%22%20alt%3D%22iNZyC%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1800319%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1800535%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Expand%20IP%20address%20range%20to%20individual%20IP%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1800535%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F839518%22%20target%3D%22_blank%22%3E%40w0llf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20only%20have%20entries%20where%20number%20after%20the%20last%20dot%20changes%2C%20such%20as%3C%2FP%3E%0A%3CP%3E10.0.0.1-10.0.0.3%3C%2FP%3E%0A%3CP%3EOr%20could%20numbers%20before%20that%20change%20to%2C%20such%20as%3C%2FP%3E%0A%3CP%3E10.0.0.128-10.0.2.255%3C%2FP%3E%0A%3CP%3Eor%20even%3C%2FP%3E%0A%3CP%3E10.0.0.0-10.1.8.127%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

 

iNZyC

1 Reply

@w0llf 

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