need to add o's in between two numbers, need help!

[Rakee]

hi , I've a problem on a formula to add zero's in between two numbers, like

if A1 16225 & B1 22546 =CONCATENATE(A1,REPT(0,9-LEN(A1)),B1) Result = 1622500022546

the problem is when i need total 13 numbers

if A1 16225 & B1 22546 =CONCATENATE(A1,REPT(0,9-LEN(A1)),B1) Result = 162250002546

Result 162200022546
16220002456

instead i need 162200022546
162200002456

Help guys!

Sorry for mistakes, Thanks in advance.

[daddylonglegs]

I get this result using that formula

16225000022546

four zeroes between the two values.

Are A1 and B1 always 5 digits? If so and you just want 3 zeroes try

=A1&"000"&B1

[martindwilson]

=a1&rept(0,13-(len(a1)+len(b1)))&b1

[Rakee]

martindwilson, If u don't mind can u explain that....?

[martindwilson]

=a1&rept(0,13-(len(a1)+len(b1)))&b1 is the same as

CONCATENATE(A1,rept(0,13-(len(a1)+len(b1))),B1)

rept(0,13-(len(a1)+len(b1))) you need 13 digits so take the total length of the original so say a1=12 b1=100 length is 5
13-5=8 so add 8 zeros