PDA

View Full Version : editing text in a cell



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

Jan Karel Pieterse
10-17-2012, 12:41 AM
=VALUE(SUBSTITUTE(G46,"Shortened Odds",""))

Martinw
10-17-2012, 01:08 AM
Hi Jan,
Thanks for that - it works a treat.
Ta,
Martin