Concatenate strings?
Thanks for the replies, that works.
"Eduardo" wrote in message
...
Hi,
=A1&" "&B1&" "&C1
"Alain Dekker" wrote:
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
.
|