Thread: quotation marks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JohnF
 
Posts: n/a
Default quotation marks

Hello,

I'm trying to include a quotation mark in a concatenated cell. The numbers
in the cells have been converted to text.

Cell1=28 Cell2=36
My formula is =(cell1 & " x " & cell2)

What is returned is 28 x 36

How can I get the concatenated cell to read 28" x 36".

Thanks
John