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

Concatenate strings?
 

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


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

Concatenate strings?
 

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


.

Concatenate strings?
 

"Raz Boyarski" wrote:
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 -----

"Raz Boyarski" wrote in message
...
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


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

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


.