Dropping/inserting a text string into an external link formula

[JDBerry]

Hello all,

I am trying to poll/extract quote information from an external source using a formula in Excel… Based on the input into cell C4, how do I insert that address into my link formula?

="PROPHETX|QUOTE!"&C4&"?Last" returns

[TABLE="width: 402"]
<tbody>[TR]
[TD="width: 402"]PROPHETX|QUOTE!ATO?Last instead of the price for ATO.

Thank you for your help

JDB[/TD]
[/TR]
</tbody>[/TABLE]