Home

Matching Names won't VLOOKUP

%3CLINGO-SUB%20id%3D%22lingo-sub-880873%22%20slang%3D%22en-US%22%3ERe%3A%20Fantasy%20Football%20-%20Matching%20Names%20won't%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880873%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416831%22%20target%3D%22_blank%22%3E%40heffjenry%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJeff%2C%3C%2FP%3E%0A%3CP%3EIn%20names%20which%20you%20copy%2Fpasted%20from%20web%20there%20are%20non-breaking%20spaces%20CHAR(160)%20instead%20of%20space%20CHAR(32)%2C%20thus%20no%20matches%20in%20names.%20Actually%20I%20checked%20only%20one%2C%20%22Daniel%20Jones%22%20-%20in%20the%20middle%20there%20is%20non-breaking%20space.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUnfortunately%20that's%20usual%20story%20with%20copy%2Fpasting%20of%20HTML%20text.%20You%20may%20replace%20non-breaking%20spaces%20on%20spaces%20manually%20-%20Ctrl%2BH%2C%20into%20Find%20what%20Alt%2B0160%20(number%20shall%20be%20entered%20from%20Numpad%20keyboard)%2C%20Replace%20on%20space%2C%20and%20replace%20all.%3C%2FP%3E%0A%3CP%3EPerhaps%20there%20are%20some%20other%20similar%20characters%2C%20I%20didn't%20check%20everything.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-880876%22%20slang%3D%22en-US%22%3ERe%3A%20Fantasy%20Football%20-%20Matching%20Names%20won't%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880876%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much.%26nbsp%3B%20Was%20hoping%20to%20just%20drop%20in%20the%20source%20data%20and%20everything%20to%20update%20automatically%20each%20week%2C%20appreciate%20you%20spotting%20the%20issue!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-880877%22%20slang%3D%22en-US%22%3ERe%3A%20Fantasy%20Football%20-%20Matching%20Names%20won't%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880877%22%20slang%3D%22en-US%22%3E%3CP%3EWORKED!%20Thank%20you.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-880878%22%20slang%3D%22en-US%22%3ERe%3A%20Fantasy%20Football%20-%20Matching%20Names%20won't%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880878%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416831%22%20target%3D%22_blank%22%3E%40heffjenry%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome.%3C%2FP%3E%0A%3CP%3ETo%20automate%20-%20perhaps%20there%20are%20ready%20to%20use%20export%20to%20Excel%20tools%20exist.%20Maybe%20could%20be%20done%20with%20Power%20Query%2C%20but%20that's%20not%2010%20minutes%20job.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-880842%22%20slang%3D%22en-US%22%3EMatching%20Names%20won't%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880842%22%20slang%3D%22en-US%22%3E%3CP%3EDeleted%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-880842%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
heffjenry
New Contributor

Deleted

4 Replies

@heffjenry 

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.

 

 

@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!

WORKED! Thank you. @Sergei Baklan 

@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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies