David McRitchie was the first to post this feature--well, that I saw.

RagDyeR wrote:

Peo, ... I remember something from a few years ago, where you *could* merge
cells and still retain the contents of *all* the cells included within the
merge.

Don't remember who, when, or why, but it had to do with the "Format
Painter".

Just tried it out now, and I'll be damned, it *does work* on my XL02
machine!

Populate all 3 cells, A1:C1, with anything, text and/or numbers.

Select any 3 *other* cells in a row, and merge them the normal way,
<Format <Cell <Alignment tab, and click on "Merge".

Click in these merged cells and then click on "Format Painter".

Now, click on A1 to copy the merge format to those cells.

The merge displays normally, with only the contents of A1 being displayed.

With the A1:C1 merge selected, once again,
<Format <Cell <Alignment tab, and click on "Merge" to *de-select* it,
then <OK.

AND ... you'll see the original data displayed ... in all 3 cells ! ! !

Kind of weird, isn't it?

Would MS call this a "feature"?<bg

--

Regards,

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

"Peo Sjoblom" wrote in message
...
Did you really merge the cells? Have you looked up merge cells in help? It
clearly states that except for the upper leftmost cell's contents the rest
will be deleted. It even warns you when you are doing this:

"The selection contains multiple data values. Merging into one cell will
keep the upper-left most data only."

Of course if you concatenated as opposed to merge this won't happen, then it
is only a matter of making the column wider. If you really merged the cells
under formatcellsalignmentmerge cells then the error is between the chair
and the computer

--

Regards,

Peo Sjoblom

"dk" wrote in message
...
ex: washington : Apt 51 ,was 2 cells merged the word apt but not the 5,
somtimes may be missing from the letter "t" from Apt till end of cell

"CLR" wrote:

Well, there's ways to do all kinds of weird things in Excel, but we would
need more details in order to offer specific help for your case.

Vaya con Dios,
Chuck, CABGx3



"dk" wrote:

We merged 2 columns together , but after we did alot of work we
realized that
some cells are missing a few right charchters is there anyway to run a
filter
& fix or mark those records seperatley

--

Dave Peterson