title: Extract Multiple text from a cell - Excel
body: <p>I have a cell with a bunch of text in it. The information I need appears multiple times in the cell but always in different spots.</p>
  
  <p>I have used this to extract the data (1 set) that I need. all the data I need starts with 00710</p>
  
  <pre><code>    =MID(L2,FIND("00710",L2),18)
  </code></pre>
  
  <p>This returns only one and I need to grab the rest if it appears in the cell. if can appear up to 5 times.</p>