Dodo,
When I paste that in J7 it says the formula you typed contains an error
and highlights the F7 after MID(. Any idea? 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)
|