CODE EXAMPLE FOR TYPESCRIPT

cell between quotation marks google spreadsheet

= CHAR (34) & A1 & CHAR (34)
If you wanna put a comma, then:
= CARACTER (34) & A1 & CARACTER (34) & CARACTER (44)