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

This works well - but
when you subtotal excel inserts the word 'total' on the same line - as
in theis example 'company name'

How can I remove the word total?

In my case I am subtotaling by invoice number - after I subtotal it
states '123456 total' - 123456 = invoice number

When I do the special copy/paste below the '123456 total' is pasted on
a new line - but I cannot have the word total there - becuase I need
to upload the invoice number as format number into another program

How can I get rid of the word total?

Thanks

On Tue, 4 Jan 2005 12:43:05 -0800, "vanjohnson"
wrote:


On your subtotaled page, summarize to the level that you want to copy (by
clicking on the numbers on the upper left).

Select all of the rows. Then select Edit - Go to, hit the "Special
Button"
and then "Visable Cells Only".

You now can go to where you want to paste, and do paste special, values.



"Robin Funnell" wrote:

How do I copy just the subtotal information to a new worksheet?