=CONCATENATE(A1,B1) with leading zero(s)

[JMC57]

How can I modify this formula =CONCATENATE(A1,B1) to allow for up to 5 leading zeros?

Thanks

 

[oldbrewer]

text(A1,"00000")

 

[JMC57]

Thanks fore your quick response. I made this work by inserting another col. can it be combined in the formula =CONCATENATE(A1,B1) ?

 

[Rick Rothstein]

Thanks fore your quick response. I made this work by inserting another col. can it be combined in the formula =CONCATENATE(A1,B1) ?

What oldbrewer was trying to get you to do is use the TEXT function on each of your original cells...

=CONCATENATE(TEXT(A1,"00000"),TEXT(B1,"00000"))

Just so you know, instead of using the CONCATENATE function, you can join text using an ampersand between them, so to join A1 and B1, instead of writing this...

=CONCATENATE(A1,B1)

you can write this instead...

=A1&B1

Applying that to your question, the first formula above (the one I say oldbrewer was trying to lead you to) could be written this way instead...

=TEXT(A1,"00000")&TEXT(B1,"00000")

 

[oldbrewer]

thanks, Rick

 

[JMC57]

Thank you!