Concatenate strings?

  • Thread starter Thread starter Alain Dekker
  • Start date Start date
A

Alain Dekker

Simple question:

I have:
"Fred" in A1
"loves" in B1
"chocolate" in C1

How do I set up a formula (like A1+B1+C1) do that in D1 I get "Fred loves
chocolate"? Is there any way to add sapces in the formula, maybe A1+" "+B1+"
"+C1? I've tried all of the above, without success.

I'm using Excep 97.

Thanks,
Alain
 
I'm not sure if this function exists in Excel 97 but in 2003 it does.

try inserting in cell D1 the formula: =Concatenate(A1,B1,C1)

if it doesn't work, try typing:

=A1 & " " & B1 & " " & C1
 
Raz Boyarski said:
try inserting in cell D1 the formula: =Concatenate(A1,B1,C1) if it doesn't
work, try typing:
=A1 & " " & B1 & " " & C1
Click to expand...

CONCATENATE(A1,B1,C1) is equivalent to A1&B1&C1, not what you wrote.


----- original message -----
 
Back
Top