1、Excel生成guid,uuid 格式:600d65bc-948a-1260-2217-fd8dfeebb1cd
=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)))
2、Excel生成guid,uuid 格式:600d65bc948a12602217fd8dfeebb1cd
=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)))
3、Excel生成guid,uuid 格式:4E3B14BB-ECF3-7B2E-A5A2-FE6E1A52DE6A
=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))
4、Excel生成guid,uuid 格式:4E3B14BBECF37B2E-A5A2FE6E1A52DE6A
=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))