Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
String Together
Hi!
Please can somebody show me how to string together this? apple fruit pear fruit orange fruit potato veg pear fruit plum furit To become this apple fruit pear fruit orange fruit apple pear orange potato veg potato pear fruit plum furit pear plum Thanks in advance -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200610/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
String Together
Assuming that "apple" "pear" and "orange" are in cells A1, A2 and A3,
respectiively, try =A1&" "&A2&" "&A3 This is a short form of the Concatenate function. Use the ampersand symbol to "join" two cells together. To get the spaces between the words, join " " to the cells, as well. HTH -- LPS "FIRSTROUNDKO via OfficeKB.com" wrote: Hi! Please can somebody show me how to string together this? apple fruit pear fruit orange fruit potato veg pear fruit plum furit To become this apple fruit pear fruit orange fruit apple pear orange potato veg potato pear fruit plum furit pear plum Thanks in advance -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200610/1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
String Together
It sounds like you need to use the Concatenate function.
Try this in cell C3 =CONCATENATE(A1," ",A2," ",A3) Good luck! SME FIRSTROUNDKO via OfficeKB.com wrote: Hi! Please can somebody show me how to string together this? apple fruit pear fruit orange fruit potato veg pear fruit plum furit To become this apple fruit pear fruit orange fruit apple pear orange potato veg potato pear fruit plum furit pear plum Thanks in advance -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200610/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
Importing Long String - String Manipulation (INVRPT) (EDI EANCOM 96a) | Excel Programming | |||
Importing Long String - String Manipulation (EDI EANCOM 96a) | Excel Programming | |||
to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
Create a formula into a String then assign string to a cell | Excel Programming |