trimming text

[Steve]

I'm working with mutual fund names that have the share
class attached to the end. I'm trying to write the
formula that would trim them so that just the name
appears. For example:

I have... I need....
Acorn Growth A Acorn Growth
Acorn Growth B Acorn Growth
Munder Total Return A Munder Total Return
Munder Total Return C Munder Total Return
Munder Total Return I Munder Total Return

 

[JE McGimpsey]

One way:

=TRIM(LEFT(A1, FIND("$", SUBSTITUTE(A1, " ", "$", LEN(A1) -
LEN(SUBSTITUTE(A1, " ", ""))))))