Auto numbering to start at another character than the first character

[lmaritz]

Good day.

I am battling to find a solution to my problem,

I have a dataset in which I have to assign a unique value to each record. I have been trying to automate the process but to no avail.

The problem is that the unique value should start with 2 letters followed by 19 numbers. Highlighting and dragging 2 or more unique numbers does not work.

Using a column that has been numbered (Column A) can work if I replace the value of the numbered column in a formula that contains the rest of the letters and numbers but I don't want to do this because I want to use the auto numbered column (Column B) to check whether the values in the first (Column A) are correct because it is possible with this dataset that the numbers in (Column A) may skip 1 on more sequential numbers.


Herewith an example of the information

 

[SanjayGMusafir]

Are you looking for this? Check this and revert -

Book1
	A	B	C
1	Number	Code	Solution
2	10480	C03900050001048000000	C03900050001048000000
3	10481		C03900050001048100000
4	10482		C03900050001048200000
5	10483		C03900050001048300000
6	10484		C03900050001048400000
7	10485		C03900050001048500000
8	10486		C03900050001048600000
9	10487		C03900050001048700000
Sheet1

Cell Formulas
Range	Formula
C2:C101	C2	="C0390005000"&SEQUENCE(100,,10480,1)&"00000"
A3:A9	A3	=A2+1
Dynamic array formulas.

 

[jkpieterse]

This might work:

=LET(first,"C03900050001048"&SEQUENCE(COUNTA(A2:A12),1,1),first&REPT("0",22-LEN(first)))

 

[lmaritz]

Thank you very much from sunny South Africa Sanjay and Jan Karel!