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:
=+A1&B1&RIGHT(C1,(LEN(C1)-1))

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.