Edit Replace formula

[snax500]

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

 

[Ken Johnson]

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

With the string in A1

=LEFT(TRIM(A1),LEN(TRIM(A1))-6)

Ken Johnson

 

[Guest]

Highlight your range

In the menu click Edit>Replace>Find Whatress space bar Total>Replace With:
<leave it blank>, then click Replace All