Remove "sum of" from pivot table name large quantities
 

I know how I can remove the "sum of" term from the column name of my
data field in a pivot table by adjusting the field properties.
However, I have many, many columns and it's very tedious to remove it
from each one. Is there an easier way to change the field names?

Remove "sum of" from pivot table name large quantities
 

Select the range
Edit|Replace
what: sum_of_
with: _
replace all
the underscore represents a space character.

Notice that the change still leaves a leading space in the field name.

FSUKC wrote:

I know how I can remove the "sum of" term from the column name of my
data field in a pivot table by adjusting the field properties.
However, I have many, many columns and it's very tedious to remove it
from each one. Is there an easier way to change the field names?

--

Dave Peterson