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. |
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) |