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