Forum Discussion
LAR-526
Jan 10, 2021Copper Contributor
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
2 Replies
Sort By
- SergeiBaklanDiamond Contributor
- LAR-526Copper ContributorThanks Sergei for the suggestion. That worked!