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

On Sat, 12 Feb 2005 19:40:02 -0500, yahoo wrote:

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

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


"yahoo" wrote in message
...
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