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" wrote in message
...
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