Excel 2003 (mid,left,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

 

[Andrew Poulsom]

Try:

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