Hi All,
it would be great if you could please help me here. well, I have two excel file A and B. the A file has employee names who are to be recruited and file B has a the data of Employee names who have joined. The problem here is the naming convention is different in both the filed i tried doing Text to column and then using concatenate function by this i was able to get few name but i missed on getting a lot of names as the names are not updated correctly. below is the example.
it would be great if you could please help me here. well, I have two excel file A and B. the A file has employee names who are to be recruited and file B has a the data of Employee names who have joined. The problem here is the naming convention is different in both the filed i tried doing Text to column and then using concatenate function by this i was able to get few name but i missed on getting a lot of names as the names are not updated correctly. below is the example.
File A Employee Name | File B Emp Name |
Martin Joseph | M joseph |
Martin Joseph | Martin J |
Praveen Kumar ujwal | Praveen K Ujjwal |