Google Sheets Trim after either of characters
<p>I have a column of cells in Google Sheets with text in the following formats:</p>

<pre><code>PLAYBILL59; Code Description Here
BROADWAYBOX59: Code Description Here
TICKETCODE: Code Description Here
</code></pre>

<p>I want to create a formula that deletes everything after and including either a colon or semi-colon, that would leave:</p>

<pre><code>PLAYBILL59
BROADWAYBOX59
TICKETCODE
</code></pre>

<p>I've been trying for hours with no luck.</p>

<p>Any suggestions very appreciated.</p>