Tuesday, October 9, 2012

yogi_Strip Characters Such As Asterik And Space Character From data Pulled From Yahoo Finance

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #799  Oct 09, 2012    www.energyefficientbuild.com.

user stewie97 said: (http://productforums.google.com/forum/?zx=j1qokp4rhrrx#!category-topic/docs/spreadsheets/GIoivmjVqWA)
I have this formula in a cell

=Query(importhtml("http://finance.yahoo.com/q/is?s="&A1&"&annual","Table","9");"select Col2 where Col1 = '*Total Revenue*'")

and it returns

*73,723,000 *

Is it possible to use substitute to strip off both the "*" and the " " while still using the existing formula?
following is a solution to the problem