Extract uppercase words from string

Hi,

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

Please Login or Register  to view this content.

Thanks in advance!

-Andrew

That did it! Only problem at first was I was getting #value, but it was due to some cells ending with arbitrary spaces. I just used the TRIM function to clean that up, and voila! Thanks!

Can anyone help me to adjust the latest code above? I actually want to keep the first word in the cell, but keep everything else as is. Thanks!

A1: The quick brown Fox Jumps over the lazy dog. It was Very Neat.

Ideally in B1: The Jumps Very Neat