Hi, I have a great formula that works most of the time to parse out an email address, but.... Sometimes they add their nick name in the field with parens and the formula pulls the nick name instead of the email address . Can you help tweek the formula?
Example:
Works
=MID(A2,SEARCH("(",A2)+1,SEARCH(")",A2)-SEARCH("(",A2)-1)
returns
aaron.wad@Certify.com
where it breaks:
Returns
Jeff
I was not sure how to write this to ignore the () with the nickname.
thanks for your help,
Sharon
Example:
Works
=MID(A2,SEARCH("(",A2)+1,SEARCH(")",A2)-SEARCH("(",A2)-1)
Aaron Wad - NTCT (aaron.wad@Certify.com) |
aaron.wad@Certify.com
where it breaks:
Aaron ( Jeff) Wad - NTCT (aaron.wad@Certify.com) |
Jeff
I was not sure how to write this to ignore the () with the nickname.
thanks for your help,
Sharon