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.

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.

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.