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
- SergeiBaklanDiamond Contributor
- LAR-526Copper ContributorThanks Sergei for the suggestion. That worked!