LinkBack URL
About LinkBacks
If I've 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.png
If I've 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.png
Put your data in column A starting at A1.
Then run this Macro
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks