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