Creating Serial Numbers with 12 Characters from 2 Columns

[Jaevwyn]

Hi Guys,

I have two columns, A and B for arguments sake.
Column A has 2-4 alpha numerical characters in it, and Column B is numbered 1-12 and then after 12 starting back at 1 again.

I need Column B to insert 0's infront of the number (1-12) inserted into the column so that the total characters of columns A and B equal 12, examples below:

Desired Result | Col A | Col B
2CN000000001 | 2CN | 000000001
LSBU00000009 | LSBU | 00000009
DT0000000012 | DT | 0000000012

I then need to merge Column A and Column B into a new Column, C for example, to make the 12 character serial.

Any Suggestions?
Thanks!

 

[wideboydixon]

Book1
	A	B	C
1	2CN	1	2CN000000001
2	LSBU	9	LSBU00000009
3	DT	12	DT0000000012
Sheet1

Cell Formulas
Range	Formula
C1	=$A1&TEXT($B1,REPT("0",12-LEN($A1)))

WBD

 

[Jaevwyn]

Perfect!
Thanks very much