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.
