View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Inserting Quotations

Assuming your information is in columns A thru G, you can write this
formula:
=CHAR(34) & A1 & CHAR(34) & ", " & CHAR(34) & B1 & CHAR(34) & ", " &
CHAR(34) & C1 & CHAR(34) & ", " & CHAR(34) & D1 & CHAR(34) & ", " &
CHAR(34) & E1 & CHAR(34) & ", " & CHAR(34) & F1 & CHAR(34) & ", " &
CHAR(34) & G1 & CHAR(34)

The CHAR(34) generates the quotation marks.