Jan 10 2021 01:21 PM - edited Jan 11 2021 05:05 AM
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
Jan 11 2021 12:07 PM
SolutionFeb 21 2021 08:30 PM
Jan 11 2021 12:07 PM
Solution