CONCATENATE formatting question

T

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
 
P

Peo Sjoblom

Try


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

or better

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