Extracting specific data from multiple cells with variable string values

%3CLINGO-SUB%20id%3D%22lingo-sub-2047197%22%20slang%3D%22en-US%22%3EExtracting%20specific%20data%20from%20multiple%20cells%20with%20variable%20string%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2047197%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20in%20advance%20for%20you%20help%20and%20apologies%20if%20am%20repeating%20someone%20else's%20post.%3C%2FP%3E%3CP%3EI%20am%20using%20a%20RIGHT%20function%20with%20a%20nested%20Search%20function%20to%20extract%20everything%20right%20of%20the%20%26lt%3B%20bracket%20but%20the%20results%20differ%20with%20each%20cell.%26nbsp%3B%20Here%20is%20the%20formula%20for%20each%20cell%20-%26nbsp%3B%3CBR%20%2F%3E%3DRIGHT(A3%2CSEARCH(%22%26lt%3B%22%2CA3)-1)%3CBR%20%2F%3ECan%20someone%20explain%20what%20I%20may%20be%20doing%20wrong%20and%20suggest%20some%20solutions.%3C%2FP%3E%3CTABLE%20width%3D%22581px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22580px%22%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20A%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22580px%22%3ESTMP%20Address%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22580px%22%3EWill%20Naunt%22%3CWILL_NAUNT%3E%3C%2FWILL_NAUNT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22580px%22%3Ematthew.philson%22%26lt%3B0xlf2b2b2b2b2bzmatthew.philson%40abc321.com%26gt%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22580px%22%3E%3CA%20href%3D%22mailto%3AIntl_Settlements%40domain123.com%2522%253Cintl_settlements%40domain123.com%253E%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EIntl_Settlements%40domain123.com%22%3CINTL_SETTLEMENTS%3E%3C%2FINTL_SETTLEMENTS%3E%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22580px%22%3E%3CA%20href%3D%22mailto%3ASettle_Department%40site123.com%2522%253Csettle_department%40site123.com%253E%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESettle_Department%40site123.com%22%3CSETTLE_DEPARTMENT%3E%3C%2FSETTLE_DEPARTMENT%3E%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22580px%22%3E!DropdomainMemostoLAM%22%3CDROPDOMAINMEMOSTOLAM%3E%3C%2FDROPDOMAINMEMOSTOLAM%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22580px%22%3E%2463O200-2K1KO1PVM9JC%22%3CDOMAINUSTEAMLEADERS%3E%3C%2FDOMAINUSTEAMLEADERS%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2047197%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

 

1 Reply

@LAR-1968 

To extract right part

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