ExcelBanter - Edit Replace formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Edit Replace formula (https://www.excelbanter.com/excel-discussion-misc-queries/119691-edit-replace-formula.html)

snax500

Edit Replace formula

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

Edit Replace formula

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

Teethless mama

Edit Replace formula

Highlight your range

In the menu click EditReplaceFind What:press space bar TotalReplace With:
<leave it blank, then click Replace All

"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

All times are GMT +1. The time now is 10:03 PM.