Thanks for the help everyone!!!
Gord Dibben wrote:
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

On Tue, 16 Jan 2007 10:08:01 -0800, Michael
wrote:

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.