Get word list and count from a column in Excel – use for word cloud

Split data in a column into individual words, remove duplicates, remove unwanted characters and count the occurrences of each word. All using the Excel 365 new functions like Reduce, Lambda, Let, TextJoin and more You can use it to create word clouds or other types of lexical analysis like text mining, word frequency analysis, natural language processing and more.

Download sample file

Contents

1. The Need – 00:00
2. The solution – 00:40
3. Unique word list – 00:51
4. Let function example – 01:11
5. Substitute function – 02:55
6. Reduce function – 03:35
7. Lambda function – 04:21
8. Textjoin – 06:29
9. Text Split – 06:45
10. Remove duplicate words – 07:09
11. Combine Words and Counts – 07:55
12. Choose to combine lists – 08:34
13. Practical use – 10:29

Related videos

Apply Excel chart templates – Macro

Three must have add-ins for Excel

Microsoft Forms to Excel – live update

Scanned PDF or picture to Excel data