title: excel formula to find maximum within same cell have multiple values of right most numbers
body: <p>I want to find maximum and minimum for right most number from same cell having multiple values, below is the how data looks.
  This all values are in same cell, ex: in cell "A1"
  I want to extract rightmost number, like 1.00,1.5,1.5,1.0,2.00,1.50,1.0,1.00 and find max and min from it.
  I am currently using Excel 2016 version.</p>
  
  <pre><code>BAEK1928_TXL_1.00
  44444922_FLR2X-A_1.5
  44447922_FL2X-B_1.5
  44444922_FL2X-B_1.0
  BAEK1928_TXL_2.00
  44444922_FLR2X-B_1.50
  44444922_FLR2X-A_1.0
  44444922_FLRY-B_1.00
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/QnaGz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QnaGz.png" alt="enter image description here"></a></p>
  
  <p>Is there any excel formula or vba code for it?</p>
  
  <p>I have tried some excel formula as below but it doesn't work as required.</p>
  
  <pre><code>=MAX(RIGHT(A1,LEN(A1)-FIND("_",A1,SEARCH("_",A1)+1))
  </code></pre>
  
  <p>Data samples below where the code not work:</p>
  
  <pre><code>KMO6722-1_THICK_0.50
  MAEJ9120_GXL_0.50
  BIN76822_FLRY-B_0.50
  KMO6722-1_THIN_0.50
  MAEJ9120_TXL_0.50
  KL STLE 2987_0.5
  MAEJ9120_SXL_0.50
  DIN76722_FLRY-A_0.50
  
  MAEJ9120_TXL_1.00
  KMO6722-1_FLR2X-B_1.00
  MAEJ9120_GXL_1.00
  BIN76822_FL2X-B_1.0
  MAEJ9120_GXL_0.50
  MAEJ9120_GXL_0.80
  BIN76822_FLR2X-A_1.0
  BIN76822_FLRY-B_1.00
  MAEJ9120_TXL_0.80
  KMO6722-1_FLR2X-B
  
  MIL-STD-104_PTFE_2.0
  BIN76822 _THIN_1.00
  BIN76822 _THIN_2.00
  MIL-STD-104_PTFE_1.0
  MAEJ9120_TXL_0.80
  BIN76822_FLRY-B_1.50
  BIN76822-1_FLR2X-B
  MAEJ9120_TXL_1.00_Sn
  PLAIN_EXRD_1.00
  MAEJ9120_TXL_2.00_Sn
  MAEJ9120_TXL_0.80_Sn
  BIN76822_TXL_1.00
  BIN76822_THIN_1.50
  </code></pre>
  
  <p>Below Snap-shot of error:</p>
  
  <p><a href="https://i.stack.imgur.com/8FSQa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8FSQa.png" alt="enter image description here"></a></p>