MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combining 3 columns into 1 column

Posted by Rupert on August 23, 2001 7:34 AM

I have three seperate columns of Data that I would like to combind into one column. How can I do this?

Example Col1 = 1
Col2 = C78E
Col3 = '0456
I want the resulting single column to read: 1C78E0456, in this case the " ' " would disapear, hopefully.

Posted by IML on August 23, 2001 7:52 AM

Assuming you are in row 1, try:

This assumes all your column C (3) have a leading apostrophy you want to get rid off. If this is not the case, please provide a few more details or examples.
Good luck.