Forum Discussion

LAR-526's avatar
LAR-526
Copper Contributor
Jan 10, 2021
Solved

Extracting specific data from multiple cells with variable string values

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>
mailto:Intl_Settlements@domain123.com%22%3Cintl_settlements@domain123.com%3E
mailto:Settle_Department@site123.com%22%3Csettle_department@site123.com%3E
!DropdomainMemostoLAM"<dropdomainmemostolam@xyy.com>
$63O200-2K1KO1PVM9JC"<domainusteamleaders@abc123.com>

 

thank you

 

Resources