extract number and use in formula from text & numbers in cell

I

ivory_kitten

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
 
I

ivory_kitten

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!
 
B

Biff

Using formula MID(C90,1,FIND("m",C90,1)-1
The answer = 25
Click to expand...

Just to FYI........

Yes, the result is 25 but that 25 is not a numeric value, it's TEXT and
could cause you to pull your hair out and/or cuss loudly.

To convert the result to a numeric number:

=MID(C90,1,FIND("m",C90)-1)*1

Or:

=LEFT(C90,FIND("m",C90)-1)*1

Biff
 
I

ivory_kitten

I will keep that in mind if I have any probs.

It is working fine as a number without updating the formula... so far!
 
Top