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