Hi -
i only want to capture the 'wx' and 'ag' from this column. the problem with this column is that some of them have '21' before them and i'm wondering how i can get just 'wx' and 'ag' in a different column without the prefix '21'
thanks
Solved! Go to Solution.
Hi @Cherkos12
Here is how you can do it. Two methods formula and regex.
Workflow:
Hope this helps : )
This helped. Thanks
Happy to help : ) @Cherkos12
Cheers and have a nice day!