Extract Certain Numbers from a Cell

[OrderTester1]

I need to extract footage from a cell that contains numbers and text (i.e. T340 BLK BRD PDM STM 3/4"x100) I need to extract the 100 because this is the footage. Sometimes, it'll just be the footage like 100, 50, 25 and then some of the cells have the footage symbol so it'll be 100', 50', 25'. Someone else created the spreadsheet and it's inconsistent. I would've had the footage symbol after all footage. Also, the footage is usually at the end of the string in the cell. In any case, I want to extract the footage number from the cell containing text and numbers, to another cell. I had created a formula or maybe used Power Query, but it would still take some of the other numbers and text out and combine it with the footage (so the cell wasn't just the footage number). Some sells would just be the footage like 100, 50, 25, etc.,, but then other cells would contain parts of the text or or other numbers (i.e. 3/4"X100). Thus, I had to review over 11,000 cells and correct the footage cells so that it only had the footage in a number format without anything else (i.e. 100, 50, 25). Do you know of a formula to do this?

 

[Joe4]

Yes, that's what I did. I used your formula and then just went in and manually corrected those other cells, but the formula helped a great deal and I appreciate the support on this. Thanks, again.

Excellent!
Yes, dealing with inconsistent, unpredictable data can be such a pain!