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. |
All times are GMT +1. The time now is 11:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com