Afternoon Guys -
I've got over 1,000 subnets which have a variety of subnet masks which I need to convert into IP Ranges. I've searched all over the place for a way to do this with Excel (or anything else) including a couple of posts on this site, but still haven't had any luck. So far, I've been able to convert all of them to CIDR format simply by duplicating the subnet mask column then perfoming a find / replace for specific mask.
I downloaded ipmask2.xls from this post on this site, added addresses and masks in the first two columns underneath, then dragged down the row from column C & D so their formulas would apply as was the pattern, but it only worked for /24 addresses.
I then went to a post that was suggested at the end of that post on this site named "Creating IP Ranges from IP Add (Network) and Subnet Mask." It includes a lot of code which seemed to work for others, but cannot figure out how to apply these in Excel to my scenario - not to mention which posts are complete code and if some are partial. Honestly never really done any code-based stuff with Excel before.
Anyone have any suggestions for how to do this - or - how to implement the code from the 2nd post perhaps? Thank You!!!
Bookmarks