Skip to content

Instantly share code, notes, and snippets.

@zinyosrim

zinyosrim/ga_number_to_spreadsheet_number.txt

Created September 27, 2018 06:19
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 zinyosrim/a2676aca30eb52395059a8b80121422a to your computer and use it in GitHub Desktop.
Save zinyosrim/a2676aca30eb52395059a8b80121422a to your computer and use it in GitHub Desktop.
Download ZIP
Spreadsheet formula to convert Google Analytics report currency format to number, e.g. €57,647.00 -> 57647
Raw
ga_number_to_spreadsheet_number.txt
=VALUE(REGEXREPLACE(REGEXEXTRACT(C8;"€([0-9]*\,[0-9]+[0-9]+)");",";""))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment