Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Putting a space in an R1C1 formula
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Putting a space in an R1C1 formula
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Putting a space in an R1C1 formula
try so: "=RC[6] &""" """ & Text(RC[7],"mm/yy")" for each quote yuu need to use in quote period you have to use doubl quot -- antoka0 ----------------------------------------------------------------------- antoka05's Profile: http://www.excelforum.com/member.php...fo&userid=2902 View this thread: http://www.excelforum.com/showthread.php?threadid=48757 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Putting a space in an R1C1 formula
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Putting a space in an R1C1 formula
That is one to signify start of a text string, two for the first quotes ( so
that it doesn't get read as end string text), space, two for the end quotes, and one to close the text string. Obvious really :-)) Bob "Caro-Kann Defence" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
R1C1 formula question | Excel Worksheet Functions | |||
how do I type "itis" without Excel putting a space "it is"? | Excel Worksheet Functions | |||
how do I stop excel putting a space after a decimal point | Excel Discussion (Misc queries) | |||
R1C1 Formula in Excel | Excel Worksheet Functions | |||
Variable in an R1C1 formula | Excel Programming |