Combine cells

J

Junderwood57

I am trying to combine 5 txt columns into one column. example. column A-E
have txt fields and in column F I would like to combine all txt in columns
A-E into one while leaving the original columns A-E the same. Please help!
Thank you!!
 
S

Stephen

In F1, put
=A1&B1&C1&D1&E1

Or, if you want spaces between:
=A1&" "&B1&" "&C1&" "&D1&" "&E1

Copy down column F as far as required.
 

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

Combine rows in a coloumn 2
Filtering unique combinations of cells 7
Date Formula 1
import data from txt file to an existing excel file 1
Excel Concatenate with line breaks but ignore blank cells 3
Combine 3 of 6 worksheets 1
Combine if 3
Multiple rows into one cell 8

Top