title: Excel VBA - Find a set of characters and set as string
body: <p>I have a set of descriptions that contain ID numbers arranged into a column. For example:</p>
  
  <p><strong>Column A</strong></p>
  
  <p>This is a description with the ID number in it ID12345.</p>
  
  <p>This is a description ID66666 with the ID number in it.</p>
  
  <p>This is ID99999 a description with  the ID number in it.</p>
  
  <p>The Id numbers are always in the format "IDXXXXX" I'd like to somehow trim away all the text in each of these cells and leave just that ID number.</p>
  
  <p>My thoughts: 
  Can this be somehow done by finding a string like "ID?????" and setting that to a variable, then replacing the contents of the cell with that variable? Or by erasing all characters in a cell -except- for "ID?????"</p>
  
  <p>Any help would be appreciated, thanks.</p>