In Excel2000, I need a formula that will replace text string. For
example, I have the following text:
Boston Total
New York Total

I want a formula to just give me

Boston
New York

I don't want to use the Edit Replace, I want a formula.

Thanks