Merging multiple columns of data into one column

R

rhett miller

Is it possible to merge multiple columns of data into on
column after using the "Text to columns" function?
 
C

Chip Pearson

Rhett,

There is no built in way to do this. You can use a formula like

=A1&B1&C1

or

=A1&" "&B1&" "&C1

to combine cells A1, B1, and C1. Copy this formula down as far as
you need to go.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
K

Ken Wright

With your data in Cols A:E, in say cell F1 put the following and copy down

=A1&B1&C1&D1&E1

or

=A1&" "&B1&" "&C1&" "&D1&" "&E1

When done, select Col F and copy and then paste special as values - You can now
delete Cols A:E
 
Top