Martinw
10-16-2012, 08:34 PM
I use webquery to grab data off the net.
Now it sometimes comes as such:- "Shortened Odds1.7". I want to remove the "Shortened Odds" so only the number shows.
I have tried:- =IF(ISERROR(VALUE(RIGHT(G46,FIND("s",G46)-1))),"",VALUE(RIGHT(G46,FIND("s",G46)1)))
But it is not working. I stole it from an old spreadsheet where is was working but was left not right.
Only some of the numbers in the column are labelled as such.
Any help would be greatly appreciated.:banghead:
Ta,
Martin
Shortened Odds1.7
Now it sometimes comes as such:- "Shortened Odds1.7". I want to remove the "Shortened Odds" so only the number shows.
I have tried:- =IF(ISERROR(VALUE(RIGHT(G46,FIND("s",G46)-1))),"",VALUE(RIGHT(G46,FIND("s",G46)1)))
But it is not working. I stole it from an old spreadsheet where is was working but was left not right.
Only some of the numbers in the column are labelled as such.
Any help would be greatly appreciated.:banghead:
Ta,
Martin
Shortened Odds1.7