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

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

=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

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.

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

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