2 Messages

Digest #3299

Re: Concatenate string for cell reference - Morningstar by ojalee1

Re: Concatenate string for cell reference - Morningstar by "Randy Harmelink" rharmelink

Messages

1a

Re: Concatenate string for cell reference - Morningstar

Fri Jan 16, 2015 9:07 pm (PST) . Posted by:

ojalee1

Can someone help me out with this formula:

=RCHGetTableCell("http://www.gurufocus.com/stock/&Ticker",-1,"Traded in Other Countries")

I know it has something to do with the concatenate because the formula works and returns the Business Description when I use:

=RCHGetTableCell("http://www.gurufocus.com/stock/MMM",-1,"Traded in Other Countries")

Thanks in advance.

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1b

Re: Concatenate string for cell reference - Morningstar

Fri Jan 16, 2015 9:51 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You aren't concatenating there. You just have a single string. The
ampersand operator is what concatenates two strings, such as:

"http://www.gurufocus.com/stock/" & Ticker

On Fri, Jan 16, 2015 at 10:07 PM, ojalee1@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Can someone help me out with this formula:
>
> =RCHGetTableCell("http://www.gurufocus.com/stock/&Ticker",-1,"Traded in
> Other Countries")
>
> I know it has something to do with the concatenate because the formula
> works and returns the Business Description when I use:
>
> =RCHGetTableCell("http://www.gurufocus.com/stock/MMM",-1,"Traded in Other
> Countries")
>
>