If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merge data from different cells
Is there an easy way to merge information that is currently in different
cells so that it's combined all into one cell? |
#2
|
|||
|
|||
If in cell A1 you have "Joe" and in cell B1 you have "Smith" if you type in
cell C1 =concatenate(A1,B1) you will get "JoeSmith"; if you want "Joe Smith" try =concatenate(A1," ",B1) That should work. "Jenny" wrote: Is there an easy way to merge information that is currently in different cells so that it's combined all into one cell? |
#3
|
|||
|
|||
Sounds perfect - thanks
"JS" wrote: If in cell A1 you have "Joe" and in cell B1 you have "Smith" if you type in cell C1 =concatenate(A1,B1) you will get "JoeSmith"; if you want "Joe Smith" try =concatenate(A1," ",B1) That should work. "Jenny" wrote: Is there an easy way to merge information that is currently in different cells so that it's combined all into one cell? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
stripping commas from merge data | Patrick Heilman | Mailmerge | 0 | December 30th, 2004 04:09 AM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
Mail merge problem when filtering data from Excel data source | Dave F | General Discussions | 5 | December 3rd, 2004 06:45 PM |
VBA Code problem error 9 | Speedy | General Discussion | 19 | October 15th, 2004 09:05 PM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |