Change spelling of items in a powerpivot column

[stephme55]

Hello. I have a column in a pivot table and I would like to change the spelling of the words in that column. How can I do that?

[MarvinP]

Hey LABaby
Is this what you are asking?
http://www.bing.com/videos/search?q=...63&FORM=VRDGAR

[stephme55]

Hi Marvin.Sorry I meant a POWER pivot table. And I want to change the words of the items in a column, not the name of a column itself. I suppose I have to do that in the original file (which I loaded in) but that's a pain because I joined 2 million rows with SQL code.