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!
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!
