Remove the word 'total' from subtotals

[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

 

[Gord Dibben]

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


Gord Dibben Excel MVP

 

[CLR]

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