View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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.