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