I have my team mates copy some names and email ids into word 2007 and they are copied as below with names and email ids mixed as shown below;
[email protected] Chean Kamaar
[email protected] Viya Rejeshri
[email protected] Shinnyeshrreyash
[email protected] Ariyaa J.B.
[email protected] Jeshwin T. Narayanappa
[email protected]
[email protected] Datta
[email protected]
[email protected] Ghani Kuzroz
[email protected] Nevanina Koppa
[email protected] Basser Berrem
I want a macro to change the above as below....
Chean Kamaar - email id - [email protected]
Viya Rejeshri - email id - [email protected]
Shinnyeshrreyash - email id - [email protected]
Ariyaa J.B. - email id - [email protected]
Jeshwin T. Narayanappa - email id - [email protected]
- email id - [email protected]
Datta - email id - [email protected]
- email id - [email protected]
Ghani Kuzroz - email id - [email protected]
Nevanina Koppa - email id - [email protected]
Basser Berrem - email id - [email protected]
Thanking you in advance.
Bookmarks