FW345A-A

Are the numbers to extract *ALWAYS* together?

Will there ever be strings like this:

F5W345A-1
1-FW345A-A
FW34A5A-A

--
Biff
Microsoft Excel MVP


"Jason W" <Jason wrote in message
...
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.