Rhon Alvarez
Member
Hi Team,
need help please!
I need to extract the email address only from a certain strings of words
Ronaldo Alvarez <ronaldo.alvarez@xxx.com>
used: =LEFT(B1,FIND(" <",B1)) to extract the name only
then used: =RIGHT(B1,LEN(B1)-LEN(LEFT(B1,FIND(" <",B1)))) to supposedly extract email address only
however, I am ending with this: <ronaldo.alvarez@xxx.com>
how would I omit the two extra characters on front "<" and at the back ">" so it would only show "ronaldo.alvarez@xxx.com"
Thanks in advance.
Rhon
need help please!
I need to extract the email address only from a certain strings of words
Ronaldo Alvarez <ronaldo.alvarez@xxx.com>
used: =LEFT(B1,FIND(" <",B1)) to extract the name only
then used: =RIGHT(B1,LEN(B1)-LEN(LEFT(B1,FIND(" <",B1)))) to supposedly extract email address only
however, I am ending with this: <ronaldo.alvarez@xxx.com>
how would I omit the two extra characters on front "<" and at the back ">" so it would only show "ronaldo.alvarez@xxx.com"
Thanks in advance.
Rhon