Previous Topic Next Topic

Replace cell content in Excel 2007

Closed
ymaher Posts 1 Registration date Saturday January 24, 2015 Status Member Last seen January 24, 2015 - Jan 24, 2015 at 09:07 AM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Jan 24, 2015 at 12:32 PM
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,
Related:

1 response

Answer 1 / 1
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Jan 24, 2015 at 12:32 PM
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.
0