Forum Discussion
Partial text matching of cell fields between two columns in different sheets to insert another cell
Those examples (a) don't fit with your descriptions (e.g., Player_Bio gives only one full name and another first only) (b) provide no reliable way to "join" based on the name, given the inconsistencies.
How would you know to connect "Gabriel" with "G. Pasquale"? The latter's name may actually be George Pasquale.
Is there not some other identifier, membership number for example, in those two tables? ... with thousands of names in a given population, even relying on FULL (and reliable) names is going to lead to ambiguities in some cases, as there are in fact more than one individual named James Smith or Mary Brown. That's the reason that the corporate HR database I managed for a while used Social Security Numbers as the reliable basis for joins such as you want to attempt.
In the absence of some reliable identifier, you're going to be faced with mountains of manual work.