concatenate a double-quote

[Jack Deuce]

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.

 

[smartin]

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.

 

[Jack Deuce]

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.