How can I combine text from several cells into one?
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.
|