Excel count no of words occurs in column

Thread Starter

Vindhyachal Takniki

Joined Nov 3, 2014
592
1. I have excel column as below:
1657341132549.png


2. Need to show in excel how many times each individual word appears like
One: 2
Two: 2
Three: 1
Five: 2

3. How to do it?
 
Top