Obtaining IP Ranges from IP Subnets (or) CIDR Notation / How to Use Specific Code

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

Thanks for the quick reply! Sure - attached are two examples.

Example#1.xlsx has 4 columns. What I'm trying to do is find some type of formula that will use the data per row from columns A+B or C so that the cooresponding IP Ranges will appear in column D. I manually converted and entered the first one as an example of the output I'm desiring.

ipmask2.xls was downloaded from the first post I mentioned. It has four columns with columns A+B being source data (same source data I have in A+B in Example1.) Columns C & D are formulas which output the ip range (C being the start of the range and D the end of the range). This would have been perfect for me so pasted in a few subnets and masks then dragged down to copy formula for C+D and it worked - but only for /24 addresses

Hope that's what you were asking for. Any suggestions? Thanks!