Hi

as you're already copying and pasting onto the next row - to remove the word
total i would just use
edit / replace
in the find box type
total
(with a space in front of it)
and in the replace box don't type anything
now do a "replace all" and see if this gives you what you want.

Cheers
JulieD


"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 Wed, 19 Jan 2005 23:57:54 +0800, "JulieD"
wrote:

Hi

if you're talking about the situation where if rows are hidden (through
the
data / subtotals function) when you select just the subtotals and copy &
paste them onto another sheet all the hidden rows come too, if so:

collapse the outline so only the subtotals are visible
select the area containing the subtotals and then choose
edit / goto and click the special button
choose visible cells only and click OK
now copy & paste as normal

Cheers
JulieD

"mmiazga" wrote in message
...
When I have a spreadsheet with subtotals, sometimes I just want to copy
the
subtotals into another sheet and forget about what is being summed to
give
me
the subtotal. How do I copy and paste only the subtotals.