CONCATENATE formatting question

[THX_1138]

I have the following values each in seperate cells:

1 (cell A1)
9.50E-5 (cell A2)
CARD (cell A3)

I wish to have a single cell looking like:

1 9.50E-5 CARD

So far, I type in a cell:

=CONCATENATE(A1," ",TEXT(A2,"SCIENTIFIC")," ",A3)

The cell returns:

#VALUE!

So, what am I doing wrong here

 

[DDM]

THX, simplify your formula to: =CONCATENATE(A1," ",A2," ",A3)

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

 

[Peo Sjoblom]

Try


=CONCATENATE(A1," ",TEXT(A2,"0.00E+00")," ",A3)

or better

=A1&" "&TEXT(A2,"0.00E+00")&" "&A3

 

[THX_1138]

Thanks Peo!!! TEXT(A2,"0.00E+00") worked