| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONCATENATE I have two text strings in cells but it wont work | Excel Discussion (Misc queries) | |||
| How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
| concatenate strings | Excel Worksheet Functions | |||
| How can I count strings within strings | Excel Worksheet Functions | |||
| space between text strings with concatenate | Excel Discussion (Misc queries) | |||
Hybrid Mode
