Ted Penner
asked on
Extract, first, last, and email address
This version of the expression extracts the email address from a string of characters contained within cell E2 and replaces those characters with the result.
I also need versions of the expression that will extract the first name and one to extract the last name.
The email address can possibly be defined as any string of characters that are separated by an @ symbol with no spaces and surrounded entirely by either a (parenthesis) or <chevrons>.
This should work in a google sheet such as this one here https://docs.google.com/spreadsheets/d/1rQ5QC6Ipr5kkBDuNnIMY05Z09Q4q7lqZ52vd0bfCvtY/edit#gid=1895941459
I also need versions of the expression that will extract the first name and one to extract the last name.
The email address can possibly be defined as any string of characters that are separated by an @ symbol with no spaces and surrounded entirely by either a (parenthesis) or <chevrons>.
This should work in a google sheet such as this one here https://docs.google.com/spreadsheets/d/1rQ5QC6Ipr5kkBDuNnIMY05Z09Q4q7lqZ52vd0bfCvtY/edit#gid=1895941459
=Regexextract(E2,"[A-z0-9._%+-]+@[A-z0-9.-]+\.[A-z]{2,4}")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I agree, just have to test over time.
So far, this is what I have.
So far, this is what I have.
=SPLIT(REGEXREPLACE(REGEXEXTRACT(E4,".*<|.*\("), "<|\(", ""), " ")
ASKER