Extract Emails Within < > Symbol In Excel

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

Capture

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))




Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply