ssblue
asked on
EXcel - i need to seperate names and email addresses
I have a list of names and email addresses with the following format. How can I separate the names from the emails?
What I have:
Column A
Smith, Sue <smithsss@yahoo.com>
What I want:
Column B Column C
Smith, Sue <smithsss@yahoo.com>
What I have:
Column A
Smith, Sue <smithsss@yahoo.com>
What I want:
Column B Column C
Smith, Sue <smithsss@yahoo.com>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, I didn't know how to use the trim and find together.
Welcome, glad that helped.
»bp
»bp
Full Name in B2:
Open in new window
Email ID in C2:Open in new window
ssblue_Split-Name---Email.xlsx