Concenate (Kjede.sammen)

  • Thread starter Thread starter Jan Eikeland
  • Start date Start date
J

Jan Eikeland

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
 
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
 
Taking a particularly tangential approach to Fermat's last theorem
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
Click to expand...

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
(e-mail address removed)
 
Back
Top