How can I combine text from several cells into one?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to combine the text in one Excel cell to another cell in the
same row? I need to combine the text of four or five cells into one cell
which would then contain the all the text of the other cells.
 
Hi Michael

In the destination cell type
=A1&" "&B1&" "&C1&" "&D1
this assumes you want a space between each item.
If you wanted a comma, use ","
If you do not want a separator just use
=A1&B1&C1&D1
 
Michael

In F1 enter =A1&B1&C1&D1&E1

If you want spaces between enter them as..........

=A1& " " & B1& " " & etc.


Gord Dibben MS Excel MVP
 
Thanks for the help everyone!!!
Gord said:
Michael

In F1 enter =A1&B1&C1&D1&E1

If you want spaces between enter them as..........

=A1& " " & B1& " " & etc.


Gord Dibben MS Excel MVP
Click to expand...
 
Back
Top