can i combine text from seperate cells into a sinle cell
 

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

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

can i combine text from seperate cells into a sinle cell
 

=concatenate(a1,b1,c1,...)
or =a1 & b1 & c1 & ...

where a1, b1 and c1 are the cells containing the statements you want to
combine
--
Rich


"Paul Gill" wrote:

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

can i combine text from seperate cells into a sinle cell
 

Paul

A1 has create one

B1 has complete staement

=A1 & " " & B1 returns create one complete statement


Gord Dibben MS Excel MVP

On Wed, 16 May 2007 15:04:01 -0700, Paul Gill
wrote:

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.

can i combine text from seperate cells into a sinle cell
 

Thankyou this worked perfectly however the completed text is at the end of
the spreadsheet and so i cannot see it. In the entry box it is just
displaying the formula rather than the completed text which is there as if i
copy and paste special the value it is displayed. Can i get the text to
display in the entry bar at the top
--
Paul


"badger_rich" wrote:

=concatenate(a1,b1,c1,...)
or =a1 & b1 & c1 & ...

where a1, b1 and c1 are the cells containing the statements you want to
combine
--
Rich


"Paul Gill" wrote:

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

can i combine text from seperate cells into a sinle cell
 

To see the concatenated text in the Formula Bar you must change the formula to a
value.

CopyPaste SpecialValueOKEsc.

Note: this wipes the formula but I think that's what you want.

Or enter the formula in an empty cell near the top of your sheet.

Where you see the results of a formula is at the cell in which you entered that
formula, not at the source cells.

Your choice of where to enter it.


Gord Dibben MS Excel MVP

On Thu, 17 May 2007 12:17:00 -0700, Paul Gill
wrote:

Thankyou this worked perfectly however the completed text is at the end of
the spreadsheet and so i cannot see it. In the entry box it is just
displaying the formula rather than the completed text which is there as if i
copy and paste special the value it is displayed. Can i get the text to
display in the entry bar at the top