Sheets treats quote marks weird since that's a character used in formulas. This is the remedy for that.

It does not work in the editor. This only works in Google Sheets