How can I combine text from several cells into one?

[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.

 

[Roger Govier]

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

 

[Gord Dibben]

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

 

[Kevin Rhinehart]

Thanks for the help everyone!!!

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