can i combine text from seperate cells into a sinle cell

[Guest]

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.

 

[JMay]

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.

 

[Guest]

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

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

 

[Gord Dibben]

Paul

A1 has create one

B1 has complete staement

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


Gord Dibben MS Excel MVP

 

[Guest]

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

 

[Gord Dibben]

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