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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help merging Excel into Publisher Booklet w 2 columns 0
Merging from an Excel file with graphics 1
Page numbering with Merged Document and IF statements 1
Booklet in Word, Merge Directory from Excel 0
Mail Merge Directory Conditional Page Break 0
How to center adjust text above and image in a two column document. 1
Two columns followed by single page-width column on same page 0
MS Project Center-Autolink column fields 0

Top