MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combine columns??


Posted by Chris Thompson on October 31, 2001 6:00 AM

Is there an easy way to combine the values of two columns into one column? For example if cell A1 contained "12345" and cell B1 had "6789", I need a function or macro that will make cell A1 equal "1234556789". I realize that I could simply cut and paste the data, but I am dealing with spreadsheets that have hundreds of rows that need the same function.

Thanks in advance for your response!

Chris Thompson


Posted by Chris Thompson on October 31, 2001 6:04 AM

Sorry.. my final result should be "123456789", I typed the extra 5 in there by accident.

Posted by Barrie Davidson on October 31, 2001 6:09 AM

Use concatenate, the formula being
=A1&B1

If you need the value, select the formula data, copy, and then PasteSpecial Values.

Regards,
BarrieBarrie Davidson

Posted by EDDIE G on October 31, 2001 6:09 AM

TYPE =A1&B1 IN CELL C1 AND DRAG IT DOWN AS FAR AS YOU NEED.