title: Separate Cell with an Address into Multiple Columns in Excel Based on Criteria
body: <p>I have a column in Excel that has varied address information like so:</p>
  
  <ul>
  <li>5 Kings Highway North, Suite 555 Cherry Hill, NJ 08043<br>
       55 Split Rock    Dr. Cherry Hill, NJ 08003<br>
       5555 Herbert St. Philadelphia, PA 19129</li>
  </ul>
  
  <p>My question is if there is any way through formulas, text to columns, or VB to separate this information in to columns like this?</p>
  
  <ul>
  <li><p>1 Column for Street Address</p>
  
  <p>1 Column for City, State, &amp; Zip</p></li>
  </ul>
  
  <p>I keep trying to think of a roundabout way, but can't seem to get the result I want with the extra address line in some but not all rows.</p>
  
  <p>Any ideas are greatly appreciated, thanks!</p>