Tuesday, January 1, 2013

yogi_Extract The Number After SELL From RSS Feed Lines

                                          Google Spreadsheet   Post  #950
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 01, 2013
user Martin Kruger  said:(http://productforums.google.com/forum/?zx=ljjtokot5b7x#!mydiscussions/docs/4NTN9vr5w2Q)
I have a cell which is taken from an RSS feed it gives me "Isogen BUY 125.02 = | SELL 172.01 (+2.01 +1.18%)"
but all i want is the number after SELL. So all i need is 172.01 into another cell, 
How do i isolate this and put it into another cell?


I use chrome with windows
Here is the link:

following is a solution to the problem