excel 2003 (left,mid,right) formula ?

[johnny52]

Actuarial_16201_CC
Actuarial_16201_CC
Corporate Accounting_10100_CC

is there a way to use a mid,left or right formula to just have the word "actuarial"
or "corporate accounting" to appear....I understand that the words are not of equal length
so I keep dropping off part of the word

 

[Scott Huish]

This will avoid an error if there is no _ in the string:

=LEFT(A1,FIND("_",A1&"_")-1)