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
some have the type
or
A few have the following :
, 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