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
 
Back
Top