It all has to do with applying specific formatting to your cells.
- Highlight the cells you want to add the quotes.
- Go to Format –> Cells –> Custom
- Copy/Paste the following into the Type field: \’@\’ or if you need additional comma at the end then: \’@\’,
- Click “okay”
- Be happy you didn’t do it all by hand.