Excel Extract username from cell that has string of numbers
<p>I have spreadsheet, that contains a string of numbers (text) I need to extract the text within the parentheses and count how many meet the critera</p>

<p>I tried the follow code:</p>

<pre><code>=COUNTIF(NASC!C:C,"MID(NASC!C:C,SEARCH(zv489408,NASC!C:C,22))")
</code></pre>

<p>But it is not returning a value.  </p>

<p>here is the string that it must search from:</p>

<pre><code>1234595250110784533 (zv489408)
</code></pre>

<p>and its on separate sheet that labelled NASC</p>