title: Extract only ALLCAPS words with regex
body: <p>Looking for a way to extract only words that are in ALL CAPS from a text string. The catch is that it shouldn't extract other words in the text string that are mixed case. </p>
  
  <p>For example, how do I use regex to extract KENTUCKY from the following sentence:</p>
  
  <blockquote>
    <p>There Are Many Options in KENTUCKY</p>
  </blockquote>
  
  <p>I'm trying to do this using <code>regexextract()</code> in Google Sheets, which uses RE2.</p>
  
  <p>Looking forward to hearing your thoughts. </p>