Incremental suite of numbers AND letters : KZ-1, KZ-2, KZ-3 ,etc.

%3CLINGO-SUB%20id%3D%22lingo-sub-3240240%22%20slang%3D%22en-US%22%3EIncremental%20suite%20of%20numbers%20AND%20letters%20%3A%20KZ-1%2C%20KZ-2%2C%20KZ-3%20%2Cetc.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3240240%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20create%20several%20lists%20of%20combinations%20with%20letters%20and%20numbers%20in%20the%20format%20%3A%3C%2FP%3E%3CP%3ECOUNTRY%20CODE%20-%20INCREMENTAL%20NUMBER%3C%2FP%3E%3CP%3EExample%20%3A%3C%2FP%3E%3CP%3EFR-1%3C%2FP%3E%3CP%3EFR-2%3C%2FP%3E%3CP%3EFR-3%3C%2FP%3E%3CP%3Eetc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20don't%20know%20how%20to%20do%20it%20easily%20with%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%20%3F%20%3CLI-EMOJI%20id%3D%22lia_winking-face%22%20title%3D%22%3Awinking_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EM.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3240240%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3240401%22%20slang%3D%22en-US%22%3ERe%3A%20Incremental%20suite%20of%20numbers%20AND%20letters%20%3A%20KZ-1%2C%20KZ-2%2C%20KZ-3%20%2Cetc.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3240401%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1321705%22%20target%3D%22_blank%22%3E%40Myriam2150%3C%2FA%3E%26nbsp%3BIf%20you%20insert%20FR-1%20in%20the%20first%20cell%20and%20then%20select%20that%20cell%20and%20left%20click%20and%20hold%20on%20the%20bottom%20right%20corner%20and%20drag%20down%20the%20column%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Doug_Robbins_Word_MVP_0-1646216090403.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F352331i3B049E5E502F7AD7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Doug_Robbins_Word_MVP_0-1646216090403.png%22%20alt%3D%22Doug_Robbins_Word_MVP_0-1646216090403.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eyou%20will%20get%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Doug_Robbins_Word_MVP_1-1646216175958.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F352332iC9A217A9FD49F91A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Doug_Robbins_Word_MVP_1-1646216175958.png%22%20alt%3D%22Doug_Robbins_Word_MVP_1-1646216175958.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone,

 

I need to create several lists of combinations with letters and numbers in the format :

COUNTRY CODE - INCREMENTAL NUMBER

Example :

FR-1

FR-2

FR-3

etc.

 

but don't know how to do it easily with excel.

 

Help ?  

 

Thanks !

 

M.

2 Replies

@Myriam2150 If you insert FR-1 in the first cell and then select that cell and left click and hold on the bottom right corner and drag down the column

Doug_Robbins_Word_MVP_0-1646216090403.png

 

you will get 

 

Doug_Robbins_Word_MVP_1-1646216175958.png

 

Hi Doug, I have been trying that all morning, somehow now that I try it, it works ! XD XD XD You must have sent some sort of energy towards my excel sheet, thanks for that !