View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default How can I combine text from several cells into one?

type = then click the first cell then "&" and the next cell and so on. If you
need a comma or something just put it in quotes between &'s such as
=A1 & ", " & A2
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


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