title: Google Sheets Extract Text between two characters
body: <p>I have a field where I need to extract the text between two characters.</p>
  <p>I've found regexextract and I got it to work when there is one character but I can't for the life get it to work with multiple characters.</p>
  <p>2020-02: Test Course (QAS)</p>
  <p>I need to extract text after : and before (</p>
  <p>So it would just return &quot;Test Course&quot;</p>
  <p>TYIA</p>