Katmic

That is the nature of merged cells. The data from only the top left cell will
be retained.

Merged cells cause no end of problems with sorting, filtering, copying,
pasting and other functions too numerous to remember or list.

Go with Otto's "center across" whenever possible.

To get the contents of two cells into one......

=A1 & B1

=A1 & " " & B1 if you want a space between contents.


Gord Dibben Excel MVP

On Mon, 28 Nov 2005 12:17:05 -0800, KatMic
wrote:

I've tried highlighting the two cells which are in the same row. It
suggested that I format and align. Both of which I've tried. I keep getting
the same error message, "The selection contains multiple data values. Merging
into one cell will keep the upper-most data only." I need to make the cells
one with all my information. Is this possible?