Hello,
So some people on this forum have been extremely helpful and have saved me hours upon hours with this project, I just need one more adjustment.
I need to extract capitalized words from a string. Previously, I requested to extract all capital words EXCLUDING:
-The first word
-One which follows a period if the cell has >1 sentence
-Specific words
Now, I take it back and want to keep the first word. Is there a simple adjustment to the following code to accomplish this? Thank you.
Example: Excluding words following a period, and the word "Fox":
A1: The quick brown Fox Jumps over the lazy dog. It was Very Neat.
ideal outcome: The Jumps Very Neat
Also: How about if we want to extract all excluding only specific words, but including all others whether they start a sentence or not?
Thanks!
Bookmarks