Finding numbers in cell with text

[Lancer7]

Cell B2 Specs: Sold for $58,500 CAD = $40,432 USD, 2009 Massey Ferguson 9795, w/4200 P/U Header., 1253 Sep Hours Cell B3 Specs: 3200 sep. hours, always stored inside, auto steer ready, excellent tires, pro drive unit, has power cast tail board for straw chopping, has 28' unloading auger, a/c works, used for wheat harvest this year. Does not sell with GPS unit-i.e. screen & globe I am trying to make column C return the "Seperator hours" from cells in column B. Column B has hundreds of cells with specs of machines and they all have the hours listed before the letters "sep" but sometimes the text "sep" has a capital S and sometimes it does not. The hours are also not always in the same place in the cell as shown above in the example of what two of the cells in the "B" column look like. I also need the result to be in number form so that I can use it in number formulas after the fact

 

[Asbestos_Jen]

Is the number of sep hours always 4 digits? If so, try this:

=--RIGHT(TEXTBEFORE(B3,"sep",1,1,0),5)

 

[dreid1011]

Another option for values longer or shorter than 4, and maybe there's a more elegant solution, but this seems to work:

=LET(t,TEXTBEFORE(LOWER(B2),"sep"),-LOOKUP(0,-RIGHT(t,ROW(INDEX(C:C,1):INDEX(C:C,LEN(t))))))

 

[Lancer7]

Not always 4 Jen but thank you! I should have mentioned that in my question as besides that it would have been perfect, Dreid that works perfect with it being 3 sometimes so thank you!

 

[dreid1011]

You're welcome, and happy to help.