How can I combine text from several cells into one?
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
--
Regards
Roger Govier
"Michael" wrote in message
...
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.
|