SOLVED

Extracting specific data from multiple cells with variable string values

Copper Contributor

Thanks in advance for you help and apologies if I am repeating someone else's similar post.

I am using a RIGHT function with a nested Search function to extract everything right of the < bracket but the results differ with each cell.  Here is the formula for each cell - *Note that cell # will change accordingly*.
=RIGHT(A3,SEARCH("<",A3)-1)
Can someone explain what I may be doing wrong and suggest some solutions.

                                                          A
STMP Address
Will Naunt"<will_naunt%eu._kwm._com@xyz.com>
matthew.philson"<0xlf2b2b2b2b2bzmatthew.philson@abc321.com>
Intl_Settlements@domain123.com"<intl_settlements@domain123.com>
Settle_Department@site123.com"<settle_department@site123.com>
!DropdomainMemostoLAM"<dropdomainmemostolam@xyy.com>
$63O200-2K1KO1PVM9JC"<domainusteamleaders@abc123.com>

 

thank you

 

2 Replies
best response confirmed by LAR-526 (Copper Contributor)
Solution

@LAR-526 

To extract right part

=RIGHT(A3,LEN(A3)-SEARCH("<",A3))
Thanks Sergei for the suggestion. That worked!
1 best response

Accepted Solutions
best response confirmed by LAR-526 (Copper Contributor)
Solution

@LAR-526 

To extract right part

=RIGHT(A3,LEN(A3)-SEARCH("<",A3))

View solution in original post