title: How to get last item in white space separated words in cell?
body: <p>For example I have 500+ rows of data that is formatted as example:
  Hamilton Washington 30 OR 12345</p>
  <p>The issue is the last item in the cell is a zip code and I need to copy it into another cell.
  The number of items in each cell is not the same so split text leaves it in different columns.</p>
  <p>I essentially want the &quot;12345&quot; or last item in the cell since for all of them it will be the zip code.</p>
  <p>Thanks</p>