Skip to content

Instantly share code, notes, and snippets.

@jruzafa

jruzafa/google_spreadsheet_double_quotes_formula.txt

Forked from roalcantara/google_spreadsheet_double_quotes_formula.txt
Last active June 20, 2019 07:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jruzafa/5715394bba8df4500dedc361ff3a30c3 to your computer and use it in GitHub Desktop.
Save jruzafa/5715394bba8df4500dedc361ff3a30c3 to your computer and use it in GitHub Desktop.
Download ZIP
Google Spreadsheet Double Quotes Formula
Raw
google_spreadsheet_double_quotes_formula.txt
Export spreadsheet as csv.
=ArrayFormula(""""&Sheet1!A:B&"""")
Open with sublime;
1.Replace """" with ""
2.Replace """ with "
source: http://stackoverflow.com/questions/3315636/how-to-enclose-every-cell-with-double-quotes-in-google-docs-spreadsheet
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment