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

On Tue, 25 Jul 2006 09:45:02 -0400, chum
wrote:


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 !