Previous Topic Next Topic

Replace cell content in Excel 2007

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

Réponse 1 / 1
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 26
24 Jan 2015 à 12:32
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.

Similar discussions

If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Convert number to spelling
Sukumar -
mrwagh85 -

28 responses