View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann
 
Posts: n/a
Default Connect two Cells without loosing content

"CLR" wrote in message
...
If you are talking about "Merging", then the answer is no.


Not quite Chuck. As was highlighted in the NG's recently, if you merge
cells in an unused part of the spreadsheet and then use the Format Painter
from these merged cells to paint the format on to the cells that you really
do want to merge, then when these second cells are un-merged again the data
is still there!

--
Regards

Sandy

Replace@mailinator with @tiscali.co.uk


"CLR" wrote in message
...
If you are talking about "Merging", then the answer is no. Excel will
keep
only the upperleftmost cell value when merging a range of cells.

If you are actually wanting to do something else, post back with more
specifics and someone will help.

Vaya con Dios,
Chuck, CABGx3



"Vic1978" wrote:


Hi,

how is it possible to connect two cells without loosing content of one
of those cells?

Thanks
Vicky


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile:
http://www.excelforum.com/member.php...o&userid=28708
View this thread:
http://www.excelforum.com/showthread...hreadid=492705