| 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 | |||
Hybrid Mode
