Forum Discussion
Merge not working despite identical value
I have two tables. Call the first #"Extracted Data" and the second #"Name Variations". Extracted Data Source Person Lead Length Encoded (merged) Employee ID Swiss Cows Doe, Michael R...
The function that encodes text as numbers returns 032 for both spaces in each of the names. I tested that function with a nbsp, and it returns 160, so that isn't it. Good thinking, though.
Fuzzy matching isn't an option for this dataset.
You are going to have to share data via Dropbox from a text file then or some other way. Pasting in the forum can strip the info out.