Forum Discussion
Matching Names won't VLOOKUP
Deleted
4 Replies
Jeff,
In names which you copy/pasted from web there are non-breaking spaces CHAR(160) instead of space CHAR(32), thus no matches in names. Actually I checked only one, "Daniel Jones" - in the middle there is non-breaking space.
Unfortunately that's usual story with copy/pasting of HTML text. You may replace non-breaking spaces on spaces manually - Ctrl+H, into Find what Alt+0160 (number shall be entered from Numpad keyboard), Replace on space, and replace all.
Perhaps there are some other similar characters, I didn't check everything.
WORKED! Thank you. SergeiBaklan
heffjenry , you are welcome.
To automate - perhaps there are ready to use export to Excel tools exist. Maybe could be done with Power Query, but that's not 10 minutes job.
SergeiBaklan Thank you so much. Was hoping to just drop in the source data and everything to update automatically each week, appreciate you spotting the issue!
