Extract Capital Words

[agf12555]

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.

Please Login or Register  to view this content.

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!

[mrice]

Try

Please Login or Register  to view this content.

[agf12555]

Sorry, didn't quite do it.

Example given:

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

This last code gives me: Jumps It Very Neat

[Leith Ross]

Hello agf12555,

This UDF macro will extract the data according to your rules.

Please Login or Register  to view this content.