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.
|