Thread: Combine cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Stephen[_2_] Stephen[_2_] is offline
external usenet poster
 
Posts: 364
Default Combine cells

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.

"Junderwood57" wrote in message
...
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!!