View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jason W Jason W is offline
external usenet poster
 
Posts: 6
Default Truncate / Substitute Formulas

Is there a formula that removes everything except numbers from a cell? For
example, if a cell contained the text FW345A-A the formula would return the
value 345. I got it to somewhat work using SUBSTITUTE on top of itself, but
there seems to be a limit in the number of characters you can add to the
string. It won't let you add all 26 letters and the dash.