Capturing special characters

[Cherkos12]

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 

[atcodedog05 · Accepted solution]

Hi @Cherkos12 

Here is how you can do it. Two methods formula and regex.

Workflow:

Hope this helps : )

[Cherkos12]

This helped. Thanks

[atcodedog05]

Happy to help : ) @Cherkos12 

Cheers and have a nice day!