Log In
Register
Home
New Member
April 26, 2021
Offline
Hi I found a website were you can put any Text in a dialog box and after that you can see which words are mostly used in there. They count it and give you also the % numbre of frequency. I would love to use something similar to this on excel, because im pretty sure its made with programming like pyhton or C.
Here you have the link to check it out( Sorry but the only good example I found is on German:
http://www.pooq.org/wortzahl/index.php
See Answer
July 16, 2010
Offline
Hi Aleksandar,
Welcome to our forum!
That's an interesting question. You can't get Excel to easily generate the list of words in a sentence, but you could use the formula below to count words you specify. Let's say this formula is in cell C1:
=(LEN(A1)-LEN(SUBSTITUTE(A1,B1,"")))/LEN(B1)
Where A1 contains your sentence and B1 contains the word you want to count. Note: this is case sensitive and you would need to enter any additional words you want to count in cell B2, B3 and so on and then copy down the formula in column C.
Alternatively, if you know VBA, you could use it to split the text by space delimiter and then summarise and count it.
Mynda
September 9, 2020
Offline
Hi Aleksandar,
Here is a (starting) proposal via Power Query. I put the text to be processed in cell A2 of the 'ORIGIN' sheet. In the 'FINAL' sheet, I update the Power Query processing which is carried out in column A. I still have to update the pivot table in column F.
I hope this will help you to start your project.
BR,
Lionel
Answers Post
1 Guest(s)
