[Google Sheet] How to join double quote

How-To

Step 1. Check double quote value in ASCII Codes Table, i.e. char(34)

Step 2. Then you can using char(34) as bellows:

=concatenate(char(34), A1, char(34))

Reference

[1] https://infoinspired.com/google-docs/spreadsheet/join-double-quotes-with-text-in-google-sheets/