Concatenate Function

[anne]

I have been trying to use the CONCATENATE function in an
Excel spreadsheet. When I use the "Insert Function" box
and enter the Function Argument, the "Formula Result="
area displays the correct result--showing the strings of
text joined together--however, when I hit OK, only the
formula is displayed in my spreadsheet, not the resulting
string.
This is the way the Insert Function box builds the formula:
=CONCATENATE(B10,F10,K6)

My text strings have alpha and numberic digits and are
formatted as text.

Any suggestions as to how I get the text strings to
display in the cell?

I appreciate any help! Thanks!!
Anne

 

[CLR]

Maybe try just =B10&F10&K6 but with either formula, be sure your
formula does not have a space before the equal sign.

Vaya con Dios,
Chuck, CABGx3