Identical Text not identical (for =, vlookup, etc) MAKING ME CRAZY

I can't figure this out to save my life, and have also googled it extensively.

I have attached a smaller version of my problem. I have 2 names- spelled the SAME no extra spaces, nothing. There is something with how the one in column A is set up that makes it not equal to the name in column B. Any suggestions as to what it is? I have tried Clean() and Trim() to fix the problem, and the issue remains. I need to figure out what formula, or formatting I can utilize on the column A line to make the resulting data able to be equal to column b. This has to be done weekly, so I can't just retype the name (which somehow does fix the problem).

Patrick Reed Problem.xlsx

The problem is with the space after Patrick. One of them is a true space the other one is a "text", I guess kind like a space generated by special symbol.

The difference is the space between the names. The one in column A uses a space commonly used on the internet. It's ascii code is 160. The name in B uses the more common space with ascii code 32.

To fix this, select your range (I'd do both columns) and do a replace (Alt H)
Find what: if you have a number pad on your keyboard Alt + 0160 (you'll see the cursor move over one space
Replace with what: use the spacebar to input a space
Replace All
Did that work for you?

The macro at this website will remove all leading/trailing
and multiple interspersed char 32 space characters.
It will also remove and/or convert char 160 non breaking
spaces into standard char 32 space characters. It will
work on text or numbers and the numbers will be
converted to true numeric numbers.

I use this macro dozens of times every single day!
It's a real time saver.

http://www.mvps.org/dmcritchie/excel/join.htm#trimal