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