Excel Magic Trick 542: PivotTable Count How Many Times A Word Occurs In Word Document
Download Files:
https://people.highline.edu/mgirvin/Y...
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
