Using Google sheets, here's what I'm trying to accomplish:
I have data that comes in like this:
xta_GAM-1a (61095) xta_SM (61096) xta_GAM2 (61156) xta_GAM-1b (61161) AO CPC ALL GAM AO CPC ALL PA AO CPC ALL SM AO CPC ALL TPP
I want to extract only the first alpha portion after the underscore, or failing that just the last alpha portion, so resulting in this:
GAM SM GAM GAM GAM PA SM TPP
How can I pull this off?
EDIT: @amit's answer got me most of the way there, and I figured out the last part on my own. Current solution is:
=if(iserror(search("_",C1)),REGEXEXTRACT(C1,".* (.*)$"),iferror(REGEXEXTRACT(REGEXREPLACE(C1,".*_", ""),"[A-Z]+"),""))
I will award to Amit unless anyone has something more compact, elegant, etc.