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

"Dodo" wrote:

?B?SmFtYnJ1aW5z?= wrote in
:

I have a web query that produces the following:

cell F7 = OVER 8 +115
cell F9 = UNDER 8 -125
cell F11= OVER 9.5 +112
cell F13= UNDER 9.5 -122
cell F15= OVER 8.5 +100
cell F17= UNDER 8.5 -110
cell F19= OVER 10 +106
cell F21= UNDER 10 -116

I would like cells J7:J21 to equal
8
8
9.5
9.5
8.5
8.5
10
10


As numbers?

In J7:

=VALUE(MID(F7;SEARCH(" ";F7);SEARCH(" ";F7;SEARCH(" ";F7)+1)-SEARCH("
";F7)))

.. . . and copy down.

As text? Then leave VALUE() out.


--

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