View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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