Concatenate strings?

[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

 

[Raz Boyarski]

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

 

[Eduardo]

Hi,

=A1&" "&B1&" "&C1

 

[Joe User]

try inserting in cell D1 the formula: =Concatenate(A1,B1,C1) if it doesn't
work, try typing:
=A1 & " " & B1 & " " & C1

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


----- original message -----

 

[Alain Dekker]

Thanks for the replies, that works.

Hi,

=A1&" "&B1&" "&C1