Just remembered ... there's a way to merge and *not* lose the data ... so
.... makes the warning unnecessary ... so ... XL doesn't display it!

*COPY* the merge format to a range, and the data in the adjoining cells is
not lost.
When you choose to un-merge the range, the data comes right back.

Merge an out-of-the-way range of cells, identical in configuration to the
range containing data, then copy that merged range to the cells in question,
using either the format painter, OR, "Paste Special - Formats".

This will give you the properties of the cell merge, *without* the loss of
data ... and of course ... without any warning messages.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"RagDyer" wrote in message
...
One approach to resolve your request is to *avoid* what the message is
warning about, therefore XL doesn't need to display it.

If *only* the top left cell of the merge range contains data, you won't
get
the warning message.
Can't you delete any data in the other cells before performing the merge?
You're going to *lose* the data anyway!

--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-

"David P." wrote in message
...
How do I turn off the warning message that says "The selection contains
multiple data values. Merging into one cell will keep the upper-left
most
data only." I would like the merge to happen without the warning. Your
help
is appreciated.
--
David P.