Name convention is not in the right format

[azzi]

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.

File A Employee Name	File B Emp Name
Martin Joseph	M joseph
Martin Joseph	Martin J
Praveen Kumar ujwal	Praveen K Ujjwal

 

[Peter_SSs]

Welcome to the MrExcel board!

You have given some sample data from the two files, but what results are you trying to achieve and which file will those results be in?

In your samples File A seems to have the 'fuller' name and File B the shortened names. Is that always the case?

 

[azzi]

Welcome to the MrExcel board!

You have given some sample data from the two files, but what results are you trying to achieve and which file will those results be in?

In your samples File A seems to have the 'fuller' name and File B the shortened names. Is that always the case?

Hi Peter,
Thanks for your reply. yes this always the case and i am trying to find who are the employee's joine using the names mentioned in file B

 

[Peter_SSs]

I'm still not sure what exact results you want for that sample data or which file those results should appear in.