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

You could highlight column and replace "Total" with "".

"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

Let me rephrase that:
You could highlight the column and Ctrl F, replace "Total" with "". This
would eliminate all "Total" words in the column .

"briank" wrote:

You could highlight column and replace "Total" with "".

"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