Merging multiple columns of data into one column

  • Thread starter Thread starter rhett miller
  • Start date Start date
R

rhett miller

Is it possible to merge multiple columns of data into on
column after using the "Text to columns" function?
 
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
 
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
 
You must log in or register to reply here.

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

Best solution to merge multiple Outlook contacts easily 2
Merging multiple columns into one column (dynamically) 1
merging multple columns into one column (dynamically) 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Merging Date Columns 7
VBA set thick borders around non empty cells in range 0
COMBINING TWO COLUMNS THAT ARE CURRENCY 2
compare and merge workbooks 1

Back
Top