2 New Messages
Digest #2608
Messages
Wed May 8, 2013 1:59 am (PDT) . Posted by:
"weekeewawa" weekeewawa
works well
however, when i tried to point to cell A1, it gives me an error
=SUBSTITUTE(SUBSTITUTE(smfGetTagContent("http://www.reuters.com/finance/stocks/companyProfile?symbol= ''&A1","div",1,"Full Description"),"</p>",CHAR(13)),"<p>",CHAR(10))
thats the code i used, is that correct?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Try:
>
> =SUBSTITUTE(SUBSTITUTE(smfGetTagContent("
> http://www.reuters.com/finance/stocks/companyProfile?symbol=GOOG.O ","div",1,"Full
> Description"),"</p>",CHAR(13)),"<p>",CHAR(10))
>
> On Wed, May 8, 2013 at 12:35 AM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > can i know what is the code to extract the ''full description'' of for
> > example
> >
> > http://www.reuters.com/finance/stocks/companyProfile?symbol=GOOG.O
> >
>
however, when i tried to point to cell A1, it gives me an error
=SUBSTITUTE(
thats the code i used, is that correct?
--- In smf_addin@yahoogrou
>
> Try:
>
> =SUBSTITUTE(
> http://www.reuters.
> Description"
>
> On Wed, May 8, 2013 at 12:35 AM, weekeewawa <weekeewawa@
>
> >
> > can i know what is the code to extract the ''full description&#
> > example
> >
> > http://www.reuters.
> >
>
Wed May 8, 2013 2:06 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You've got an extra double quote after the A1 cell reference.
On Wed, May 8, 2013 at 1:59 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
> works well
>
> however, when i tried to point to cell A1, it gives me an error
>
> =SUBSTITUTE(SUBSTITUTE(smfGetTagContent("
> http://www.reuters.com/finance/stocks/companyProfile?symbol= ''&A1","div",1,"Full
> Description"),"</p>",CHAR(13)),"<p>",CHAR(10))
>
> thats the code i used, is that correct?
>
On Wed, May 8, 2013 at 1:59 AM, weekeewawa <weekeewawa@yahoo.
> works well
>
> however, when i tried to point to cell A1, it gives me an error
>
> =SUBSTITUTE(
> http://www.reuters.
> Description"
>
> thats the code i used, is that correct?
>
Tidak ada komentar:
Posting Komentar