can i combine text from seperate cells into a sinle cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Gill - 16 May 2007 23:04 GMT

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.

Signature

Paul

Reply to this Message

JMay - 16 May 2007 23:14 GMT

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.

> 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

Reply to this Message

badger_rich - 16 May 2007 23:16 GMT

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

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

Signature

Rich

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

Reply to this Message

Paul Gill - 17 May 2007 20:17 GMT

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

Signature

Paul

> =concatenate(a1,b1,c1,...)
> or =a1 & b1 & c1 & ...
[quoted text clipped - 4 lines]
> > 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.

Reply to this Message

Gord Dibben - 18 May 2007 02:08 GMT

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

Copy>Paste Special>Value>OK>Esc.

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

>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

Reply to this Message

Gord Dibben - 16 May 2007 23:54 GMT

Paul

A1 has create one

B1 has complete staement

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

Gord Dibben MS Excel MVP

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

Reply to this Message