title: How to extract specific text from a cell?
body: <p>In this case, I want to extract the beginning text in a cell and leave the remainder intact.
  e.g. a series of cells contain:</p>
  
  <pre><code>2nd Unit. Miami
  3rd Production Staff. Toronto
  1st Ad. San Francisco
  </code></pre>
  
  <p>I want to break this up without using Text to columns as previous rows are formatted differently and these last few rows are outliers that I want to handle.</p>
  
  <p>I thought Regular Expressions might do it, but that seems a bit complex.</p>
  
  <p>My algorithm idea is:
  1. grab the wanted text (what function or custom sub would do that?)
  2. Past the text to it's new location
  3. Cut the text from the cell, leaving the remaining text.</p>
  
  <p>Seems simple but I'm still wending my way through VBA forest, and at the rate I'm going it's going to end up faster doing it by hand. But this seems like a good opportunity to learn some VBA tricks.</p>
  
  <p>TIA</p>
  
  <p>Update:
  I want to take the text up to the ".\ " and move it to a different column, keeping the remainder where it is.</p>