Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand IP Address range from slash notation to individual IPs...
I would like to use Excel to take a range of IPs in slash notation and
convert it to a list of all the individual IP addresses. Does anyone know of a way to do this? I know I can enter the first IP of the range and drag the corner of the cell to expand, but I would rather do it with a formula or macro that understands the subnet and expands it correctly. I enter: 10.0.0.0/24 I would like: 10.0.0.1 10.0.0.2 10.0.0.3 .. .. .. 10.0.0.254 I am using Excel 2002. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expand a Named Range in 2007 | New Users to Excel | |||
Range that expand | Excel Discussion (Misc queries) | |||
how does one expand individual cells? | Excel Discussion (Misc queries) | |||
Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
Data Range Will Not Expand | Excel Worksheet Functions |