Trying to Delete Text Before and after < > respectfully on the same line

Hi guys I have a file that contains about 6000 rows of email addresses some have <> around them some don't. I'm trying to clean it up so I included a cleansed example.

To Delete Text Before < and to Delete Text After > on the same line I used

D2=RIGHT(C2,LEN(C2)-FIND("<",C2))
E2=LEFT(D2,FIND(">",D2)-1)

That works good but what about the lines that have no <>?
Then is there a better way to possibly make that permanent by copying E, pasting it into notepad, and coping it again into F, to remove all extra stuff then remove C,D,E.
Making F the new C

Why not use find replace.

Select your column

Find "<", replace with "", Replace all

Find ">", replace with "", Replace all


Ahh I see the issue in your sample

Try this formula in D2

Formula:

Please Login or Register  to view this content.