title: excel extract word (GB) and number before it
body: <p>I have stuck I have excel sheet I need to extract GB and numbers from a string.
    Galaxy S10+ 8/128GB (Snapdragon 855) should be 128GB have no idea how to do it. cannot find any formulas which will use whilecard , any help?</p>
  
  <p>I am using </p>
  
  <blockquote>
    <p>=IF((LEN(A3)-LEN(SUBSTITUTE(A3," ","")))&lt;2,A3,LEFT(A3,FIND(" ",A3,FIND(" ",A3)+1)-1))
    to extract phone name but stusk with a GB for it </p>
  </blockquote>
  
  <p><a href="https://i.stack.imgur.com/IfOp8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IfOp8.png" alt="enter image description here"></a></p>