Apr 23 2021 03:37 PM
I'm be working with Excel 365 and wish make a table of columns of IP Addresses. for example:
Network > 128.45.0.0
next > 128.45.1.0
next > 128.45.2.0 > etc.
So But Not wok.
How can you help me? because I've already checked the options in the editing section?
I'm looking forward for Your comments.
Apr 23 2021 11:07 PM
Hi there,
You may solve this issue with simple formula and use of & (ampersand).
Please note attached picture and excel file for your further consideration.
Good luck.
Apr 24 2021 01:43 AM
If you are on Office 365 that could be something like
=LET(start, "128.45.", end, ".0", nodes, 254, start & SEQUENCE(nodes,,0) & end)