Putting a space in an R1C1 formula
Thanks! I guess I didn't go far enough (triple quotes!)
Thanks again (all that responded).
"Bob Phillips" wrote:
Try
"=RC[6]&" & """ """ & "&Text(RC[7],""mm/yy"")"
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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
|