snax500 wrote:
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