@pathrudu thanks for your quick response.
My input sheet 1 will have the names like “Horton Jeremy email@example.com” i want it to be split up into
Last name : Horton
First name : Jeremy
Mail_Id : firstname.lastname@example.org
once it is been split i want it to be written in an excel sheet as Last name, First name in a single column by concatenating it
again i will have one more sheet 2 to compare , which will have the name column as in the formats of Last name, First name or First name , Last name.
what I need here is based on the sheet 1’s output (Last name, First name) i have to compare it with sheet 2 which has different format and make it right by overwriting it as in (Last name, First name)
once this process is done, again i need to compare sheet 1 and sheet 2 for the names and write the matched names in the format of Last name, First name in the new excel file.
Write it back for any clarification, your help will make a great difference in my work progression.