View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alain Dekker Alain Dekker is offline
external usenet poster
 
Posts: 12
Default Concatenate strings?

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