title: Separate address elements from 1 cell in Excel
body: <p>I have thousands of addresses in this format:</p>
  
  <p>123 Happy St. Kansas City, MO 64521</p>
  
  <p>9812 Main Street Minneapolis, MN 62154</p>
  
  <p>12 Virgina Ave, Apt 8, Dallas, TX 54334</p>
  
  <p>I want to extract the address, city, state, zip into individual cells (without using VB if possible).  I've tried a couple variations of other methods posted, but I can't quite get desired results.</p>