Text to word list and search

This is the continuation of the earlier video

Text to word list and search. Earlier we started with a list of text and identified individual word and their frequency of occurrence. We removed punctuation characters from original text. In this video 1. We will remove a list of common words like “the” “is” and so on 2. We will have the ability to click on any word and filter the original list The stop list and punctuation list is editable.

Download the zip from here. (This file contains a macro.)

Contents

1. The need – 00:00
2. The solution – 01:28
3. See two shees together – 02:47
4. How to use this file – 04:26
5. Add your data – 04:55
6. How was this done? – 05:27
7. Removing characters vs words – 05:45
8. Customize Stop Words – 07:19

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

4 ways to open multiple Excel files instantly

7 New Excel Features

Write data using stylus in Excel – Action Pen