Edit Replace formula

S

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
 
K

Ken Johnson

snax500 said:
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
Click to expand...

With the string in A1

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

Ken Johnson
 
T

Teethless mama

Highlight your range

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