Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 24 October 2018
  0 Replies
  2.6K Visits
0
Votes
Undo
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
There are no replies made for this post yet.