Generating GUID in excel

Excel is a very useful tool when trying to manipulate data and seeing the results right away. Using the built-in functions, you can generate a GUID :


The following combination of functions generate a GUID:

=LOWER(CONCATENATE(DEC2HEX(RANDBETWEEN(0,4294967295),8),"-",DEC2HEX(RANDBETWEEN(0,42949),4),"-",DEC2HEX(RANDBETWEEN(0,42949),4),"-",DEC2HEX(RANDBETWEEN(0,42949),4),"-",DEC2HEX(RANDBETWEEN(0,4294967295),8),DEC2HEX(RANDBETWEEN(0,42949),4)))

Author: Dev

Full Stack Developer at one of the largest Banks in Canada.