Sep 28 2019 01:22 PM - edited Sep 28 2019 04:48 PM
Deleted
Sep 28 2019 01:57 PM
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.
Sep 28 2019 01:59 PM - edited Sep 28 2019 02:00 PM
@Sergei Baklan 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!
Sep 28 2019 02:06 PM
WORKED! Thank you. @Sergei Baklan
Sep 28 2019 02:12 PM
@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.