View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 422
Default can i combine text from separate cells into a single cell


Yes, Enter as follows:
A1: My Name is
B1: Paul
C1: Gill

in an empty cell, say D1 enter =A1 & " " & B1 & " " & C1
the & character acts as a concatenator of the cells A1, B1 and C1.



"Paul Gill" wrote in message
:

Is it possible in excell where a series of statements contained in seperate
cells can be combined in another cell to create one complete statement.

--
Paul