Autocomplete

%3CLINGO-SUB%20id%3D%22lingo-sub-2283222%22%20slang%3D%22es-ES%22%3EAutocomplete%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2283222%22%20slang%3D%22es-ES%22%3E%3CP%3EI'm%20be%20working%20with%20Excel%20365%20and%20wish%20make%20a%20table%20of%20columns%20of%20IP%20Addresses.%20for%20example%3A%3C%2FP%3E%3CP%3ENetwork%20%26gt%3B%20128.45.0.0%3C%2FP%3E%3CP%3Enext%20%26gt%3B%20128.45.1.0%3C%2FP%3E%3CP%3Enext%20%26gt%3B%20128.45.2.0%20%26gt%3B%20etc.%3C%2FP%3E%3CP%3ESo%20But%20Not%20wok.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20you%20help%20me%3Fbecause%20I've%20already%20checked%20the%20options%20in%20the%20editing%20section%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20forward%20for%20Your%20comments.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2283222%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2284421%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2284421%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1035357%22%20target%3D%22_blank%22%3E%40alvarouribe222132%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3EYou%20may%20solve%20this%20issue%20with%20simple%20formula%20and%20use%20of%20%26amp%3B%20(ampersand).%3C%2FP%3E%3CP%3EPlease%20note%20attached%20picture%20and%20excel%20file%20for%20your%20further%20consideration.%3C%2FP%3E%3CP%3EGood%20luck.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

2 Replies

@alvarouribe222132 

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.

 

@alvarouribe222132 

If you are on Office 365 that could be something like

=LET(start, "128.45.", end, ".0", nodes, 254, start & SEQUENCE(nodes,,0) & end)