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.