Extract all text before Final space in cell

[jomili]

I have a column of 12,000+ titles formatted as below:
FBA General Acct II
FBI Posn Cntrl Spec III
CIA Director V

For each title, I'd like to strip off the final text string to get to:
FBA General Acct
FBI Posn Cntrl Spec
CIA Director

How do I do that?

[Special-K]

=LEFT(A1,SEARCH("^^",SUBSTITUTE(A1," ","^^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))-1)

Source:
http://www.ozgrid.com/forum/showthread.php?t=39983

[LaffyAffy13]

Another solution, if all of your data is in column A:

Please Login or Register  to view this content.

[jomili]

Sweet, both a formulaic and a VBA routine. Thanks so much! I also found another formula solution:

Please Login or Register  to view this content.