CONCATENATE

[serge]

Hi,
I'm using this formula =CONCATENATE('D4 11'!A234,'D4 111'!A234)*1
It take a number from different tab but the return is not right when I get 01 or 00 for example :
if I have first tab 39 and the second tab 01 this CONCATENATE return 391 and I need 3901 or
if I have first tab 39 and the second tab 00 this CONCATENATE return 390 and I need 3900
Can this be fix Please ?
Thank you.

 

[awoohaw]

TRY:

=CONCATENATE(Text('D4 11'!A234,"#00"),Text('D4 111'!A234,"#00"))*1

Do you ever need 2 leading zeros?

Book1
	A	B	C
2	=CONCATENATE(TEXT(B3,"#000"),TEXT(C3,"#000"))*1
3	2003	2	3
Sheet7

Cell Formulas
Range	Formula
A2	A2	=FORMULATEXT(A3)
A3	A3	=CONCATENATE(TEXT(B3,"#000"),TEXT(C3,"#000"))*1

 

[serge]

So quick, Thank you very much awoohaw it works fine now, I appreciate your help. no need 3 leading zeros yet but if I do ?

 

[awoohaw]

my pleasure.
I updated my suggestion with a 2 leading zero formula. Just add more zeros for however many you need.

Best Wishes.

 

[serge]

Ok Thank you so much awoohaw.