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

Copper 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 !