I was trying to extract capital words from a string, and was given a great code seen below. My original goal was to extract capital letter like seen in Example 1 below. Now I am wondering if anyone can help me with EXCLUDING the following:
- The first word in the string
- Any words which begin a new sentence if the cell includes multiple sentences.
- A specific word, like Fox
Example 1 (Original):
A1: The quick brown Fox Jumps over the lazy dog.
Ideally in B1: The Fox Jumps
Example 2 (New) Excluding words beginning a sentence and the word Fox:
A1: The quick brown Fox Jumps over the lazy dog. It was Very Neat.
Ideally in A1: Jumps Very Neat
Thanks in advance!