Replace cell content in Excel 2007

[Closed]
Report
Posts
1
Registration date
Saturday January 24, 2015
Status
Member
Last seen
January 24, 2015
-
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
-
Hello,
I've two columns like below and i'd like to replace the one in 1st column with the one in column B in another table.

Name_A Name_B
Joe Joeee
Patrick Patrck
Josef Jozef

ID Name Phone
1 Joe +12345
2 Patrickk +09876
3 Josefff +56789

to be :

ID Name Phone
1 Joeee +12345
2 Patrckk +09876
3 Jozefff +56789

Thanks a lot,

1 reply

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
Sorry its not possible to do this en-masse because not all the fields being matched actually match.
Only 'Joeee' matches the others do not.
It is possible to do what's called a 'fuzzy match' but this requires a LOT of coding and even then is not 100% accurate.