Merging

[Beginner2005]

Hi
If i have information in cell a1 & b1 is there any way to merge the two
cells and keep all info, in other words just a normal cell merge but instead
of just retaining the info must upper left it retains all info?

any help greatly appreciated.

Alan

[Paul B]

Alan, you could use a formula in another cell and put the two cells
together, then paste special valves, something like this

=A1&B1
or
=A1&" "&B1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Beginner2005" <Beginner2005@discussions.microsoft.com> wrote in message
news:F9D119FE-E315-49A9-B693-6F348212F4A9@microsoft.com...
> Hi
> If i have information in cell a1 & b1 is there any way to merge the two
> cells and keep all info, in other words just a normal cell merge but
instead
> of just retaining the info must upper left it retains all info?
>
> any help greatly appreciated.
>
> Alan

[Beginner2005]

Thanks Paul but i cant get it to work (probably me doing something wrong
actually)

i have the word 'Red' in A1, the word 'Blue' in B1 and want the words' Red
Blue' to appear in C1 but just cant get it to work at all

am i just being a bit thick?


"Paul B" wrote:

> Alan, you could use a formula in another cell and put the two cells
> together, then paste special valves, something like this
>
> =A1&B1
> or
> =A1&" "&B1
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Beginner2005" <Beginner2005@discussions.microsoft.com> wrote in message
> news:F9D119FE-E315-49A9-B693-6F348212F4A9@microsoft.com...
> > Hi
> > If i have information in cell a1 & b1 is there any way to merge the two
> > cells and keep all info, in other words just a normal cell merge but
> instead
> > of just retaining the info must upper left it retains all info?
> >
> > any help greatly appreciated.
> >
> > Alan
>
>
>

[Dave Peterson]

You may want to try Paul's suggestion once more.

Or post what you tried and what happened when you tried it.

Beginner2005 wrote:
>
> Thanks Paul but i cant get it to work (probably me doing something wrong
> actually)
>
> i have the word 'Red' in A1, the word 'Blue' in B1 and want the words' Red
> Blue' to appear in C1 but just cant get it to work at all
>
> am i just being a bit thick?
>
> "Paul B" wrote:
>
> > Alan, you could use a formula in another cell and put the two cells
> > together, then paste special valves, something like this
> >
> > =A1&B1
> > or
> > =A1&" "&B1
> >
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "Beginner2005" <Beginner2005@discussions.microsoft.com> wrote in message
> > news:F9D119FE-E315-49A9-B693-6F348212F4A9@microsoft.com...
> > > Hi
> > > If i have information in cell a1 & b1 is there any way to merge the two
> > > cells and keep all info, in other words just a normal cell merge but
> > instead
> > > of just retaining the info must upper left it retains all info?
> > >
> > > any help greatly appreciated.
> > >
> > > Alan
> >
> >
> >

--

Dave Peterson