title: Extract substring after '-' character in Google Sheets
body: <p>I am using the following formula to extract the substring <code>venue01</code> from column C, the problem is that when value string in column C is shorter it only extracts the value 1 I need it to extract anything straight after the <code>-</code> (dash) no matter the length of the value text in column c</p>
  
  <pre><code>={"VenueID";ARRAYFORMULA(IF(ISBLANK(A2:A),"",RIGHT(C2:C,SEARCH("-",C2:C)-21)))}
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/JIWgG.png" rel="noreferrer"><img src="https://i.stack.imgur.com/JIWgG.png" alt="enter image description here"></a></p>