Let’s see how we could extract email that is present within <> symbol in excel.
In corporate email ids and in some other format also, we see that the email addresses are enclosed within <> symbol i.e. First Last flastname@xxxx.com
Enter the formula below in cell B2 to get the email address between <> symbol in excel.
=MID(LEFT(A2,FIND(“>”,A2)-1),FIND(“<“,A2)+1,LEN(A2))
Hope this helped.
