Extract X-number of words that surround a keyword or keywords in Excel

dparnell

New Member
Joined
Nov 2, 2019
Messages
7
Hello - I would like to find a way to (i) extract a certain number of words, that surround a keyword/s (and include the keyword in the extraction, and (ii) have the keyword/s colored in the extraction.

I have ~90,000 biographies that I am looking to "classify", based on keywords. With that said, I need to determine which keywords are representative of certain biography types. So, what I envision is that I determine some core, fundamental keywords that are representative of a particular classification, and then, I will run a macro that extracts those keywords, and the words that immediately surround them into a new cell. This way, I could much more easily scan the information.

Please let me know if this (i) makes sense, and (ii) if it is achievable. Thanks so much for any help!
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,108,644
Messages
5,524,048
Members
409,557
Latest member
lgambit

This Week's Hot Topics

Top