Excel 2010 Find NOT Working

Pecoflyer · #1 04-21-2015, 11:42 AM

Probably presence of non printable characters like CHR(160) or CHR(10)
Please post a sample sheet ( no pics please)

Pstloui · #2 04-21-2015, 12:04 PM

Hi Pecoflyer, I had to strip out most of the data to be in compliance with the file upload size limitation, but I think there is enough left for you to see what's going on. The next to the last row is where control-find would not locate the second occurrence of 'DWANA GRACE-PRUITT'. I have also deleted quite a bit of info to make this as generic as possible.

What we have here is a GIGO situation where the system has no established data entry integrity constraints. Approximately 60,000 records wherein it is my task to identify duplicate businesses and names. Stripping out all special characters, I created a compkey that pretty much did that for business name, however, I did not have that luxury for contacts. You will see names entered in no particular order, including/excluding periods, commas, initials, prefix, suffix, etc. (a true mess). I used color coding to help me identify where I was as I worked my way through.

I didn't see any imbedded special characters when reviewing in Notepad, but I am not perfect and it is possible there are some. This anomally had/has me frustrated, as the control-find problem is happening again, and I am truly puzzled. Any thoughts? Help!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and Replace is not working	Brigitte	Word	7	06-15-2021 05:10 PM
Why is this Find string not working	TechEd	Word VBA	5	07-05-2014 08:12 PM
Find/Replace is not working - Excel 2010	fieldhaven	Excel	2	02-19-2014 08:30 AM
Find and Replace not working	alance	Word	2	01-24-2014 02:11 AM
Excel 2010 drag-and-drop enabled but not working	BobBridges	Excel	1	05-28-2013 09:23 AM