autofill column with increments

[LFKim2018]

what is the formula to populate a column with alphanumeric string?
the string is to be used as product code..
say, starting at LFK101 - LFK102 - LFK103 (increment) so on down..
the string can be any number of letters and numbers..
like A1, ABC123, XYZ110.... the letter is always at the left and the numbers are at the right side of the string..
maximum letter = 10; maximum number to reach = 10,000
many many thanks

 

[jtakw]

Hi,

You don't need a formula.

Enter the First Product Code in cell, Select that cell, left click on the cell Handle (little "square" at lower right corner of cell) and drag down as far as you need:

Book1
	A	B	C	D	E
1	LFK101	A1	ABC123	XYZ110	JIWEHUISEV005
2	LFK102	A2	ABC124	XYZ111	JIWEHUISEV006
3	LFK103	A3	ABC125	XYZ112	JIWEHUISEV007
4	LFK104	A4	ABC126	XYZ113	JIWEHUISEV008
5	LFK105	A5	ABC127	XYZ114	JIWEHUISEV009
6	LFK106	A6	ABC128	XYZ115	JIWEHUISEV010
7	LFK107	A7	ABC129	XYZ116	JIWEHUISEV011
8	LFK108	A8	ABC130	XYZ117	JIWEHUISEV012
9	LFK109	A9	ABC131	XYZ118	JIWEHUISEV013
10	LFK110	A10	ABC132	XYZ119	JIWEHUISEV014
Sheet248

 

[LFKim2018]

just learned another!
thank you very very much jtakw

 

[jtakw]

You're welcome.