Regular Expressions 101

1st Alternative(?m)^\s*[[:upper:]][[:alpha:]]*

(?m)applies the following effective flags to the remainder of the pattern: gm

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

^start of line

\s*any whitespace character, repeated any number of times

Character Class[[:upper:]]

[:upper:]an uppercase letter [A-Z]

Character Class[[:alpha:]]*

*matches any number of characters from the set below:

[:alpha:]an alphabetic character [a-zA-Z]

2nd Alternative.*?([[:upper:]][[:alpha:]]*|$)

.*?any character (except for line terminators), repeated any number of times

Group 1([[:upper:]][[:alpha:]]*|$)

1st Alternative[[:upper:]][[:alpha:]]*

Character Class[[:upper:]]

[:upper:]an uppercase letter [A-Z]

Character Class[[:alpha:]]*

*matches any number of characters from the set below:

[:alpha:]an alphabetic character [a-zA-Z]

2nd Alternative$

$end of line

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(?m)^\s*[[:upper:]][[:alpha:]]*|.*?([[:upper:]][[:alpha:]]*|$)

New

Words of sentences (that are preceeded by a Space and a Period), and also ignoring the first word of the cell
How to extract Words with Uppercase first letter only
With

Regular Expression

Extraction