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. |
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. |
All times are GMT +1. The time now is 12:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com