lizmorton1990
New Member
- Joined
- Aug 19, 2020
- Messages
- 15
- Office Version
- 2013
- Platform
- Windows
Hi,
I have a number of email addresses that have the name in the front and I need to extract just the email address to do a vlookup on. I have used this formula so far =TRIM(RIGHT(SUBSTITUTE(LEFT(H2,FIND (" ",H2&" ",FIND("@",H2))-3)," ", REPT(" ",LEN(H2))),LEN(H2))) which has helped but there is a < at the start of the email address i.e joe.bloggs <joe.bloggs@xyz.com>,
The formula above has resulted in <joe.bloggs@xyz.com
How do I remove the < at the start?
I have a number of email addresses that have the name in the front and I need to extract just the email address to do a vlookup on. I have used this formula so far =TRIM(RIGHT(SUBSTITUTE(LEFT(H2,FIND (" ",H2&" ",FIND("@",H2))-3)," ", REPT(" ",LEN(H2))),LEN(H2))) which has helped but there is a < at the start of the email address i.e joe.bloggs <joe.bloggs@xyz.com>,
The formula above has resulted in <joe.bloggs@xyz.com
How do I remove the < at the start?
