I get OVER. There is a space before the word over or under. Does that
matter? thanks

"Dodo" wrote:

?B?SmFtYnJ1aW5z?= wrote in
:

I realized the formula you gave me contained ; instead of ,. I change
all the ; to , but now it gives me #VALUE!. Any ideas? Thanks


Sorry, forgot to change my ";" NL separator to your local ",".

Does the #VALUE! happen in all rows?

I get the same error when I e.g. change "OVER 9,5 +112" to "OVER 9.5 +112"
because then the result between value() is not a valid number format here
(the reverse for you).

Did you try to use:

=MID(F7,SEARCH(" ",F7),SEARCH(" ",F7,SEARCH(" ",F7)+1)-SEARCH(" ",F7))

What do you get then?


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)