hello,
I am writing to seek help, in developing a macro which can pick out extra fullstops and spaces in email hyperlink and erase them.
for example:
input data in column J
Dennis [email protected]
Arthur.De [email protected]
Charles (Yi)[email protected]
Clinton [email protected]
Edward.Hacker, [email protected]
Francis [email protected]
desired output:
update column J
[email protected]
Arthur.De [email protected]
Charles (Yi)[email protected]
Clinton [email protected]
Edward.Hacker, [email protected]
[email protected]
the format of the emails should be "f_name.l_name@###.com"
Please note: there is a if formula the cells of column J.
Thank you for your help in advance.
Bookmarks