View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Alain Dekker Alain Dekker is offline
external usenet poster
 
Posts: 12
Default 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


.