title: EXCEL VBA: extracting 8 digits sequence from a string in cell
body: <p>Good day everyone,</p>
  
  <p>I am trying to find a smart solution of extracting 8 digits from a cell (unique ID). The problem here occurs that it might look like this:</p>
  
  <pre><code>112, 65478411, sale
  746, id65478411, sale 12.50
  999, 65478411
  999, id65478411
  </code></pre>
  
  <p>Thats most of the cases, and probably all mentioned, so I basically need to find the 8 digits in the cell and extract them into different cell. Does anyone have any ideas? I though of eliminating the first characted, then check if the cell is starting with the id, eliminate it further but I understood that this is not the smart way..</p>
  
  <p>Thank you for the insights.</p>