Remove portion of text from cells

[glenlee]

When subtotating, the subtotal row shows as "John Smith Total". How
do you remove the word Total from all the subtotal rows?

 

[Dave Peterson]

Select that column and do
edit|Replace
what: _total (_ = space bar)
with: (leave blank)
replace all