"MAX" not returning a value determined by a series of formula

[andymalan]

Greetings everyone. I am trying to extract values from text and then returning the result as a number and not succeeding.
e.g. text in B3: Floor Unit w/2 doors 900mm. I need the 900mm to be returned as a number, 900.
So far I have indeed managed to extract the 900 to a cell by using the "substitute" formula, but when I apply the "MAX" formula, it returns a zero.
Formula in EE3 IF(ISNUMBER(SEARCH($EA$1,$B3)), RIGHT($B3, 6),"") returns 900mm
Formula in EC3 SUBSTITUTE(EE3,"mm"," ") returns 900
Formula in IT3 MAX(DW3,EC3,EI3,EO3,EU3,FA3,FG3) returns 0

your help will be greatly appreciated.

 

[andymalan]

Thank you

You're welcome, thanks for the feedback.

Let me know if you want further help with the number extraction from your text string(s)
Refer to my post #6.

 

[andymalan]

Thank you

thank you very much JTA, as I said STAR!!