Serializing Data in Excel Column

[Samael2021]

Hello Dear,
Could you please help me with this? I have many data in a column of excel. I want to serialize them by formula or vba.
Column A data can be any random number starting with "CARD". I want those random number into a serialize form as shown in below. Thanks you so much.


COLUMN A COLUMN A (OUTPUT)

CARD001 CARD001
CARD005 CARD002
CARD009 CARD003
CARD020 CARD004

 

[JvdV]

Book1
	A	B
1	CARD001	CARD001
2	CARD005	CARD002
3	CARD009	CARD003
4	CARD020	CARD004
Sheet2

Cell Formulas
Range	Formula
B1:B4	B1	="CARD"&TEXT(ROW(A1:A4),"000")
Dynamic array formulas.

 

[Legacy 143009]

You don't need to do anything special. Just write CARD001 to any cell and pull it down. Excel will recognize number series.

 

[Samael2021]

Book1
	A	B
1	CARD001	CARD001
2	CARD005	CARD002
3	CARD009	CARD003
4	CARD020	CARD004
Sheet2

Cell Formulas
Range	Formula
B1:B4	B1	="CARD"&TEXT(ROW(A1:A4),"000")
Dynamic array formulas.

Thank you so much..

 

[Samael2021]

You don't need to do anything special. Just write CARD001 to any cell and pull it down. Excel will recognize number series.

Thanks.