Skip to content

Instantly share code, notes, and snippets.

@jhnferraris

jhnferraris/uuid_v4_excel_formula.txt

Forked from msubel/uuid_v4_excel_formula.txt
Created February 21, 2019 01:57
Show Gist options
  • Save jhnferraris/e92a49c0967c754d009da688865e7dec to your computer and use it in GitHub Desktop.
Save jhnferraris/e92a49c0967c754d009da688865e7dec to your computer and use it in GitHub Desktop.
Download ZIP
An Excel Fromula to generate a UUID v4
Raw
uuid_v4_excel_formula.txt
=LOWER(CONCATENATE(DEC2HEX(RANDBETWEEN(0;POWER(16;8));8);"-";DEC2HEX(RANDBETWEEN(0;POWER(16;4));4);"-";"4";DEC2HEX(RANDBETWEEN(0;POWER(16;3));3);"-";DEC2HEX(RANDBETWEEN(8;11));DEC2HEX(RANDBETWEEN(0;POWER(16;3));3);"-";DEC2HEX(RANDBETWEEN(0;POWER(16;8));8);DEC2HEX(RANDBETWEEN(0;POWER(16;4));4)))
@jhnferraris
Copy link
Author

https://gist.github.com/msubel/9c70951a20efe5c72195#gistcomment-2170055

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment