Since the text in each cell has a single blank between the "words", you can
use:

Select the cells. Pulldown Data Text to Columns...
use the space as a delimiter and split the cell up into three parts. Keep
the middle part.
--
Gary's Student


"Jambruins" wrote:

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

How would I do this? Thanks


I would like to setup cells J7:J21 so they are equal to