excel中生成32位随机id

时间:2024-03-08 17:30:57

记录下如何在EXCEL中利用公式生成32位的随机id(无符号,只有数字和小写字母)。

=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)))

示例:620e65bc427c32702917fd8dfaebb2df。

 

"我们就这样,各自奔天涯。"