Excel Forum



Excel Magic Trick 542: PivotTable Count How Many Times A Word Occurs In Word Document


See how to take a word document and extract all the words and get them into a column to we can use a Pivot Table PivotTable to count how many times each word occurs. See Tricks like:
1)Find and Replace In Word
2)Go To Special Blanks
3)Delete Cells
4)Text to Column to separate words into individual ells
5)Paste Special Transpose
6)Paste All Feature in Clip Board
7)Pivot Table PivotTable to count how many times each word occurs





Got a Question? Ask it Here in the Forum.