title: Filtering within a single cell using excel
body: <p>I have a spreadsheet with two columns (A, and B ).</p>
  <p>Column A is a list of funds/companies and column B is funding rounds the companies have participated.</p>
  <p>Within each cell there is multiples values separated by a semi-colon (;).</p>
  <p>Example:</p>
  <pre><code>Depixus, Series A, 2021 ; Egle Therapeutics, Series A, 2022 ; Amolyt Pharma, Series B, 2020.
  </code></pre>
  <p>My question is there a way to filter the values within a cell. Currently all the values within the cells in column B are not in year order (2022, 2021, 2020 etc).</p>
  <p>I need to get them in descending order:</p>
  <pre><code>Egle Therapeutics, Series A, 2022 ; Depixus, Series A, 2021 ; Amolyt Pharma, Series B, 2020) 
  </code></pre>
  <p>in an efficient quick way that doesn't involve manually redoing them.</p>
  <p>When utilizing the formula in the answers:
  <a href="https://i.stack.imgur.com/EHiYI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EHiYI.png" alt="FUsing the formula below" /></a></p>