Remove the word 'total' from subtotals

  • Thread starter Thread starter yahoo
  • Start date Start date
Y

yahoo

Hi

I am doing a subtotal using hte sum function

After excel subtotals it inserts the word 'total' in the same line as
the field being subtotal

How can I remove total? I need to take the subtotaled info and upload
it into another program and it will not work with the word totoal
there

Thanks
 
Have you tried F2 and edit the cell contents to remove what you don't want?


Gord Dibben Excel MVP
 
Highlight the column with the word "total" in it, then
Edit > Replace > Find What: Total > Replace with: (leave blank) > ReplaceAll
button

Vaya con Dios,
Chuck CABGx3
 
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

Getting Text data using the Data - Subtotal feature 1
Conditional SUBTOTAL in XL210 Table 7
EXCEL 2003 - SUBTOTALS 1
Totaling Subtotals 2
multiple subtotals in pivot table 1
description of count in subtotal 1
Subtotal placement issue 2
Sorting Subtotals 11

Back
Top