deleting part of a cell

C

CGodet

I am using the subtotal function in a worksheet. Is there a way to do this without MS Excel adding the word "TOTAL" at each break?
 
L

Lady Layla

Easiest way to get rid of the word total is go to the subtotal level (level 2)
select all rows you want total deleted from, F5, Special, visible cells only,
Then Find -- enter total Replace -- leave blank, replace all


: I am using the subtotal function in a worksheet. Is there a way to do this
without MS Excel adding the word "TOTAL" at each break?
 
Top