View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default Escape character for double quotes

Steve

=A1 & """" & B1 & """"


Gord Dibben Excel MVP

On Fri, 23 Dec 2005 01:02:42 -0600, SteveFox
wrote:


I have AAA in cell A1 and BBB in cell B1 and I want to use the
concatenate function to output the below in cell C1 but I having
trouble printing double quotes ".


AAA"BBB"


Could someone please tell me the escape charater to do this?