Connect two Cells without loosing content

Hi,

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

Thanks
Vicky

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

Vicky

A1 contains Vicky

B1 contains Lastname

C1 enter =A1 & " " & B1 returns Vicky Lastname

Copy C1 and Paste Special(in place)>Value>OK>Esc

Delete A1 and B1


Gord Dibben Excel MVP

On Mon, 12 Dec 2005 08:22:00 -0600, Vic1978
<Vic1978.1zxl3m_1134397500.463@excelforum-nospam.com> wrote:

>
>Hi,
>
>how is it possible to connect two cells without loosing content of one
>of those cells?
>
>Thanks
>Vicky

"CLR" <CLR@discussions.microsoft.com> wrote in message
news:12CE9474-71DE-4113-A0E9-51A08F258D59@microsoft.com...
> 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
sandymann@mailinator.com
Replace@mailinator with @tiscali.co.uk


"CLR" <CLR@discussions.microsoft.com> wrote in message
news:12CE9474-71DE-4113-A0E9-51A08F258D59@microsoft.com...
> 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
>>
>>

INteresting Sandy, thanks for the info.......I can't even begin to imagine
the circumstances that I might want to take advantage of that feature, but
interesting nonetheless.....I'll keep it in mind, maybe something will come
up.

Vaya con Dios,
Chuck, CABGx3




"Sandy Mann" <sandymann2@mailinator.com> wrote in message
news:#dYY9g0$FHA.916@TK2MSFTNGP10.phx.gbl...
> "CLR" <CLR@discussions.microsoft.com> wrote in message
> news:12CE9474-71DE-4113-A0E9-51A08F258D59@microsoft.com...
> > 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
> sandymann@mailinator.com
> Replace@mailinator with @tiscali.co.uk
>
>
> "CLR" <CLR@discussions.microsoft.com> wrote in message
> news:12CE9474-71DE-4113-A0E9-51A08F258D59@microsoft.com...
> > 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
> >>
> >>
>
>

Other than as a parlor trick, I don't think you want to use
something that is undocumented (actually, I believe, contrary to
documentation). And will not survive once you unmerge.

"CLR" <croberts@tampabay.rr.com> wrote in message news:O3LqEb2$FHA.2320@TK2MSFTNGP11.phx.gbl...
> INteresting Sandy, thanks for the info.......I can't even begin to imagine
> the circumstances that I might want to take advantage of that feature, but
> interesting nonetheless.....I'll keep it in mind, maybe something will come
> up.