title: Excel text to colum, reverse the outcome
body: <p>I have a long list of addresses, the whole address is in a single cell, each 'line' of the address is separated by a comma. I need to be able to extract just the post code. An example of the current data is as follows,</p>
  
  <pre><code>Red House, Street, Town, City, YO13 9DY
  Blue House, Street, YP8 2FR
  Black House, Street, City, L10 1AA
  Green House, Street, Street 2, Town, City, PO5T CDE
  </code></pre>
  
  <p>As you can see each address follows the same pattern, using the same comma as divider, however all are different lengths.</p>
  
  <p>Text to columns works to some extent, but due to the layout of each cell, the post code always ends up in a different column.</p>
  
  <p>Is there a way to reverse this output, so similar to Text to Columns, but each deliminator is printed in reverse order?</p>
  
  <p>If I not explained this very well please say and I shall attempt to re-word.</p>