Duplicate row with name and proper email adress

Question

Hi,

My name is Maxime, I'm new to this forum, hello to everyone !

I have a question about Kutools for Excel,

I have a database of thousand of email and I'm searching for a macro to duplicate a line with the name of the company, first name and last mail linked to the address.

Not all the email address have the type firstname.lastname@company.com some have the type flastname@company.com or f.lastname@company.com

A few have the following : firstnamelastname@company.com, I can do them manually.

I would like to do automatically the following :

- First duplicate the lines who have multiple mail address, they are marked by ";space " and put the one created in yellow. Those who have only one mail are marked by ";". In the attachment, I added XX for the stuff I would like to duplicate.
- Delete the other emails for any line created
- Highlight the modified lines in yellow
- Then to automaticaly add to the first name and last name column the one in the email adress. (With a capital at the first letter)

Can you help me please ?

Thanks you ! test.zip