Remove "sum of" from pivot table name large quantities

F

FSUKC

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?
 
D

Dave Peterson

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.
 
Top