Hi Caro-Kann Defence,

Try:

= "=RC[6] & "" "" & TEXT(RC[7],""mm/yy"")"

---
Regards,
Norman


"Caro-Kann Defence" wrote in
message ...
Hello.

I have tried quotes, double quotes and other methods without success. I am
trying to create an R1C1 formula that looks something like the following:

"=RC[6] &" & " " & " & Text(RC[7],"mm/yy")"

So the resulting formula on the worksheet should be:

=Z6 & " " & Text(AA6,"mm/yy")

This is so I can concatenate a stock ticker and the month/year and insert
this string on a chart.

Thanks,
CKD