View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Paul Keenan Paul Keenan is offline
external usenet poster
 
Posts: 5
Default Concenate (Kjede.sammen)

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