merge several cells with text into 1 cell

[chum]

Hi,

I'd like to know if it is possible to merge several cells fulfilled
with text into one cell only ?

ex.:
cell A1: name
cell A2: address
cell A3: age

to convert into wether in cell A1 containg these 3 lines or in another
cell.

thanks !

 

[jetted]

Hi Chum

You can use the function concatenate see sample attached

Thanks
Denis


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5093 |
+-------------------------------------------------------------------+

 

[chum]

Hi Jetted,

thanks a lot, this is exactly what I was looking for !

Chum

 

[Guest]

Hi Chum - If you want to end up with a single cell and not have to keep A1,A2
and A3

A1 B1 C1 D1
Name address age =CONCATENATE(A1,B1,C1)

then copy D1 and Paste Special / Values to another cell. You can Copy Paste
Special a whole block of cells if you have lots to do. Hope this helps.

 

[Gord Dibben]

You have been shown how to do this, but I would caution you against doing it.

How will you sort, filter or otherwise work with the data while it is all in one
cell?

Is there some compelling reason to have contents in one cell?


Gord Dibben MS Excel MVP