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