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 S..Connolly@cgcpc.com
Arthur.De Joya@dejoyagriffith.com
Charles (Yi).Yin@marcumbp.com
Clinton F.Bateman@abbmgroup.com
Edward.Hacker, Jr@hackerjohnson.com
Francis J..Grady@cgcpc.com
desired output:
update column J
Dennis.Connolly@cgcpc.com
Arthur.De Joya@dejoyagriffith.com
Charles (Yi).Yin@marcumbp.com
Clinton F.Bateman@abbmgroup.com
Edward.Hacker, Jr@hackerjohnson.com
Francis.Grady@cgcpc.com
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