Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
merge columns
Greetings.
I have data in Column B (same text in each field) that I want to add to all of the fields in Column A (different text in each field) I have tried merge & center and tried to work out how to do a CONCATENATE but am totally stuck. Is there any way to add the sentence in Col B to the end of the text in Col A without cutting and pasting on every line?? Tell me there is an easy way to do this!! If its a formula I need to use - where on earth do you write it?? Many thanks in advance |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
merge columns
=A1&B1 (as a formula in cell C1, for example) will do your concatenation (or
=A1&" "&B1 if you want to insert a space between the strings). If you want to replace A1 by that result, select column C, copy, select column A, Edit/ Paste Special/ Values, then you can delete column C (and B if you wish to). -- David Biddulph "Richard Rosser" wrote in message ... Greetings. I have data in Column B (same text in each field) that I want to add to all of the fields in Column A (different text in each field) I have tried merge & center and tried to work out how to do a CONCATENATE but am totally stuck. Is there any way to add the sentence in Col B to the end of the text in Col A without cutting and pasting on every line?? Tell me there is an easy way to do this!! If its a formula I need to use - where on earth do you write it?? Many thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to merge columns | Excel Worksheet Functions | |||
merge columns | Excel Worksheet Functions | |||
merge columns e with f into e. | New Users to Excel | |||
merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
I want to merge two columns | New Users to Excel |