Sorry for wasting everyone's time, I figured it out already!

Text in cell C90 = 25m3/hour
Using formula MID(C90,1,FIND("m",C90,1)-1
The answer = 25

Thanks anyways!

"ivory_kitten" wrote:

The text in my cell is 25m3/hour and I want to use 25 in my formula, how do
I use functions to do this? It is not always 25 though, it could be a one,
two or three digit number. and there could be more than one digit mixed in
with the text that I don't want to include