title: Excel Formula to get text between last two commas
body: <p>I have this data in cell A1:</p>
  
  <pre><code>Majestic Properties Design District, LLC, Ste. 101, 35 NE 40TH ST, Miami, FL 33137
  </code></pre>
  
  <p>There are a few other cells with these format address too, e.g.</p>
  
  <pre><code>Fortune International Realty Iriondo Ecker &amp; Assoc. Inc., Ste 25, 260 Crandon Blvd, Key Biscayne, FL 33149
  </code></pre>
  
  <p>The output I want is</p>
  
  <pre><code>Miami
  Key Biscayne
  </code></pre>
  
  <p>and so on</p>
  
  <p>To get the Zip and State I did</p>
  
  <pre><code>=RIGHT(A1,8)
  </code></pre>
  
  <p>However now I need to get the city (that is the text between two commas from the last).</p>
  
  <p>I do not want to use TEXT to COLUMN or any VBA. I would like to use a formula.</p>