title: Matching function of a regular expression in excel?
body: <p>I have several cells in my sheet which contain an <a href="http://en.wikipedia.org/wiki/International_Securities_Identification_Number" rel="nofollow">ISIN</a>.</p>
  
  <p>Here is an example of an ISIN: <code>DE0006231004</code></p>
  
  <p>I have created a regular expression which matches the ISIN: 
  <code>^[a-zA-Z]{2}[0-9]{10}$</code></p>
  
  <p>I want to match this regex on my cell and give a 1 if it matches otherwise a 0.</p>
  
  <p>Is this possible with a function?</p>