Check three things:

Make sure the cell format is set to "general"

Make sure you are using an equal sign (=) in front of the
concatenate function.

Double check the spelling of the function "Concatenate"

In the future, an easier method would be to use the
ampersand (instead of concatenate):
=A1&B1&C1
Any text you wish to add to the function should be
enveloped in double quotes
=A1&B1&C1&"Test"

Allan Koodray



-----Original Message-----
envir excel in office97, winxphome
Cells in columns A B C and H is text formatted and
contain names.
Concenate(A1;B1;C1)
Hi , putting this function in my H-cell doesnt show
anything else than the
formula itself.
I surely would see the three names into one name in cell
H.

Any tips?
thank You
regards jan


.