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
|