After you copy and paste

Select that column (columns) and do:
Edit|Replace
what: _subtotal (_ represents a space character)
with: (leave blank)
replace all



Debby Bunce wrote:

To all experts,

Please could you help me

i have a list of people( more than 1 entry for the same person) in column a
and and a number in column b

i can get excel to do the subtotal function

i need to copy the subtotaled data to another part of my spreadsheet but one
thing is annoying is that it says

A.SMITH SUBTOTAL 999

how do i remove the word subtotal from the cell but still keeping the
persons name

hope anyone can help

thanks in advance

steve

--

Dave Peterson