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