deleting part of a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

description of count in subtotal 1
Getting Text data using the Data - Subtotal feature 1
Skip Copying a protected cell with subtotal 2
Copy within a subtotal 1
Paste Special Values 2
subtotal titles 1
Subtotals 2
Removing extra characters in a cell 3

Back
Top