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

Jan Eikeland previously wrote:

Concenate(A1;B1;C1)

Concatenate(A1,B1,C1)

Regards

Peter Russell

thank You.
there must have been some fuzz in a cell,after I deleted all from cells and
put in
english or norwegian statement it works.
reg jan

"Peter Russell" skrev i melding
net.com...
Jan Eikeland previously wrote:

Concenate(A1;B1;C1)

Concatenate(A1,B1,C1)

Regards

Peter Russell

Taking a particularly tangential approach to Fermat's last theorem
"Jan Eikeland" proposed in
:

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

Hi Jan,

You need an equals sign to start you off, the function name is
spelled "concatenate" and you should have commas rather than
semicolons. Try :

=concatenate(a1,b1,c1)

Hope that helps.

--
pjk

"If I have not seen as far as others, it is because giants were
standing on my shoulders."
-- Hal Abelson

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


.