CODEWITHSUNDEEP
excelms-office
Dreadlord
Dreadlord

Reputation: 413

Extracting emails from excel string

So I found few forumlas online to do this but every single time I get this error:

http://postimg.org/image/4flyu43kp/

I have no idea whats going on. Im using office professional plus 2013. Here is an example how emails are placed in strings

name / something <[email protected]>
<[email protected]>

All emails are in brackets BTW < > I need to extract just the email, can someone plz help me?

Upvotes: 0

Views: 53

Answers (1)

Gary&#39;s Student
Gary&#39;s Student

Reputation: 96753

With a string in A1, in B1 enter:

=SUBSTITUTE((MID(A1,FIND("<",A1,1)+1,9999)),">","")

EDIT:

So if A1 contains:

something<[email protected]>

B1 will display:

[email protected]

Upvotes: 1

Related Questions