title: How can I find the greatest alpha numeric value by number
body: <p>I am trying to find a formula that will find the greatest numeric value in a column with strings of alphanumeric values. I want it to match the letters but find the greatest number within that match. E.g.</p>
  
  <pre>
  E
  SW0044
  MO0001
  MO0002
  MO0003
  MO0004</pre>
  
  <p>So in Column 'E' I want to match the greatest <code>MO</code> number - which is MO0004 in this case. Is there anyway you can help?</p>