| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenate a double-quote
Trying to create a text string with ". The best I can do is generate
a single-quote and then find/replace the single for a double-quote. I also tried using chr(34). I want to create a text sring from two cells in Excel. ="copy "&A2&" "&$A$1 I'd like the result to be== copy "f:\file" "l:\directory" <== generating the double-quotes before and after the filename and directory. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate a double-quote
Jack Deuce wrote:
Trying to create a text string with ". The best I can do is generate a single-quote and then find/replace the single for a double-quote. I also tried using chr(34). I want to create a text sring from two cells in Excel. ="copy "&A2&" "&$A$1 I'd like the result to be== copy "f:\file" "l:\directory" <== generating the double-quotes before and after the filename and directory. Thanks. The unintuitive answer is to use quadruple quotes: ="copy " & """" &A2& """" & " " & """" &$A$1& """" You could also place " in a cell and refer to that instead of the quad-quotes. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate a double-quote
thanks. On Sun, 28 Jun 2009 15:46:20 -0400, smartin wrote: Jack Deuce wrote: Trying to create a text string with ". The best I can do is generate a single-quote and then find/replace the single for a double-quote. I also tried using chr(34). I want to create a text sring from two cells in Excel. ="copy "&A2&" "&$A$1 I'd like the result to be== copy "f:\file" "l:\directory" <== generating the double-quotes before and after the filename and directory. Thanks. The unintuitive answer is to use quadruple quotes: ="copy " & """" &A2& """" & " " & """" &$A$1& """" You could also place " in a cell and refer to that instead of the quad-quotes. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can the SUBSTITUTE function replace a double quote? | Excel Worksheet Functions | |||
| How do I change text qualifier from double quote? | Excel Discussion (Misc queries) | |||
| Double quote delimiter script | Excel Worksheet Functions | |||
| Exporting single or double quote delimited files | Excel Worksheet Functions | |||
| how do I create comma and double quote delimited file | Excel Discussion (Misc queries) | |||
Linear Mode
