View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jack Deuce Jack Deuce is offline
external usenet poster
 
Posts: 30
Default 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.