In cell G7:
=FIND("ER",F7)
In cell H7:
=MID(F7,G7+3,3)
In cell I7:
=SUBSTITUTE(H7,"+","")
In cell J7:
=SUBSTITUTE(I7,"-","")
Copy G7 to J7 down.

"Jambruins" wrote:

Is there any way to have it done automatically? Something like the right or
left function? Thanks

"Martin P" wrote:

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