title: How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
body: <p>How can I use regular expressions in Excel and take advantage of Excel's powerful grid-like setup for data manipulation?</p>
  
  <ul>
  <li>In-cell function to return a matched pattern or replaced value in a string.</li>
  <li>Sub to loop through a column of data and extract matches to adjacent cells.</li>
  <li>What setup is necessary?</li>
  <li>What are Excel's special characters for Regular expressions?</li>
  </ul>
  
  <hr>
  
  <p>I understand Regex is not ideal for many situations (<a href="https://stackoverflow.com/a/4098123/2521004">To use or not to use regular expressions?</a>) since excel can use <code>Left</code>, <code>Mid</code>, <code>Right</code>, <code>Instr</code> type commands for similar manipulations.  </p>