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 !


--
chum
------------------------------------------------------------------------
chum's Profile: http://www.excelforum.com/member.php...o&userid=34262
View this thread: http://www.excelforum.com/showthread...hreadid=564703

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

--
jetted
------------------------------------------------------------------------
jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532
View this thread: http://www.excelforum.com/showthread...hreadid=564703

Hi Jetted,

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

Chum


--
chum
------------------------------------------------------------------------
chum's Profile: http://www.excelforum.com/member.php...o&userid=34262
View this thread: http://www.excelforum.com/showthread...hreadid=564703

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.

"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 !


--
chum
------------------------------------------------------------------------
chum's Profile: http://www.excelforum.com/member.php...o&userid=34262
View this thread: http://www.excelforum.com/showthread...hreadid=564703

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 !