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.