| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I merge the contents of two columns?
I have two columns of text (thousands of rows) that I would like to be in one
column. Ex.: 4568-15-651 and FR to 4568-15-651FR. I have done this before i just can't remember how. Help. |
|
#2
|
|||
|
|||
|
You need to use a third column
=A1&B1 copy down and the copy and paste special as values in place If you want a space between the values =A1&" "&B1 a comma and a space =A1&", "&B1 Regards, Peo Sjoblom "adamnabors" wrote: I have two columns of text (thousands of rows) that I would like to be in one column. Ex.: 4568-15-651 and FR to 4568-15-651FR. I have done this before i just can't remember how. Help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
| Can I use side by side colums and stacked columns in same graph? | Charts and Charting in Excel | |||
| Multiple Worksheets and Print Merge function | Excel Discussion (Misc queries) | |||
| Drop-down selection fills data across multiple columns | Excel Discussion (Misc queries) | |||
| Mail merge to a chart | Charts and Charting in Excel | |||
Linear Mode
