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.
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.