Formula for concat with leading zeros and max total characters

[demonfreak]

Hello,

I have a problem that I need help with. I have a set of data that contains 3 columns with variable numeral character counts. I need all rows to be concatenated and all 13 digits long (adding leading zeros where necessary.).

Here's an example set of data of what it is currently and what end results I'm looking for.

CL 1	CL 2	CL 3	End Results
1234​	123​	1​	0123400012301
1234​	1234​	2​	0123400123402
1234​	12345​	20​	0123401234520
1234​	123456​	10​	0123412345610

Thank you for any help.

 

[mrshl9898]

Try

=TEXT(A2,"00000")&TEXT(B2,"000000")&TEXT(C2,"00")

or

=CONCAT(TEXT(A2,"00000"),TEXT(B2,"000000"),TEXT(C2,"00"))

 

[demonfreak]

That worked great! Thank you for the help!!!