To me the easiest is to this via Word.
Copy the contents of the cells to Word.
In Word:
Go to Edit, Replace and (with Wildcards enabled) replace ([0-9.]{1,}) [+-]
with \1 and set the font in the Replace With field to Bold.
Then change paragraph marks to Bold.
Remove everything that is not Bold.
Copy what remains to J17:J21

"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