Excel生成guid、uuid函数

最新推荐文章于 2024-05-17 17:14:42 发布
最新推荐文章于 2024-05-17 17:14:42 发布
阅读量8.3k 收藏 8
点赞数 4
文章标签： Excel生成guid、uuid函数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/flyingshadower/article/details/90409186
版权

 

 

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

如图 将代码直接copy 到单元格即可 

那二楹
关注
  • 4
    点赞
  • 踩
  • 8
    收藏
    觉得还不错? 一键收藏
  • 3
    评论
Excel生成Guid（UUID）常用格式
CircleSeven的博客
01-13 3874
一、名词解释 维基百科：通用唯一识别码（英语：Universally Unique Identifier，缩写：UUID）是用于计算机体系中以识别信息数目的一个128位标识符，还有相关的术语：全局唯一标识符（GUID）。 根据标准方法生成，不依赖中央机构的注册和分配，UUID具有唯一性，这与其他大多数编号方案不同。重复UUID码概率接近零，可以忽略不计。 UUID的标准型式包含32个16进制数字，以连字号分为五段，形式为 8-4-4-4-12 的32个字符。示例： 550e8400-e29b-41d4-a7
PHP中生成UUID自定义函数分享
10-24
使用这个自定义函数非常简单，直接调用 `com_create_guid()` 即可生成一个新的 UUID Version 4。例如： ```php $uuid = com_create_guid(); echo $uuid; // 输出类似：123e4567-e89b-42d3-a456-307b014a8000的字符...
EXCEL生产32位UUID（大写）
Wang_Jerry2015的博客
11-22 934
=UPPER(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),DEC2
Excel生成不重复的UUID
足迹
02-20 2100
第一步：在单元格中使用函数。第二步：下拉批量生成。
excel生成uuid
最新发布
zhaofuqiangmycomm的博客
05-17 741
在excel中下拉即可。
Excel生成guid、uuid
qq_36523888的博客
08-14 6702
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...
excel生成uuid的函数
weixin_42455301的博客
09-01 2894
excel生成uuid的函数 =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
excel 表生成uuid函数
h1403635700的博客
08-25 464
=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),DEC2
Excel生成guid【转】
webmastor的专栏http://www.anymoe.com
06-11 2418
Excel生成guid 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(RANDBE..
php GUID生成函数和类
12-18
上述函数首先使用`md5`函数生成一个基于当前时间和随机数的32位16进制字符串，然后通过`uniqid`函数添加额外的随机性，以确保更小的重复概率。最后，通过切片和连接操作，将字符串格式化成GUID的标准形式。 如果你...
详解php中生成标准uuid（guid）的方法
01-03
UUID是指在一台机器上生成的数字，它保证对在同一时空中的所有机器都是唯一的。 通常平台 会提供生成UUID的API。UUID按照开放软件基金会(OSF)制定的标准计算...关于 UUID这个标准使用最普遍的是微软的GUID(Globals Uni
excel生成不重复随机值
06-13
利用excel函数生成不重复随机值，初级excel用户使用
excel某列生成uuid(自用)
dengpaoS的博客
04-04 1846
1.在如图所示位置输入函数。2.鼠标划定一片区域。
【无标题】
weixin_44324815的博客
09-19 145
UUID
Excel生成UUID
sushiyi651的博客
05-31 1612
1、Excel生成UUID格式：600d65bc-948a-1260-2217-fd8dfeebb1cd。2、Excel生成UUID格式：BC65D2D39CE5E291E053E5500A120FC0。
【mysql、excel生成uuid格式总结】
m0_46459413的博客
02-16 2418
2、Excel生成去除横杠uuid 格式（获取小写的32位随机ID：）：600d65bc948a12602217fd8dfeebb1cs。1、Excel生成uuid 格式：600d65bc-948a-1260-2217-fd8dfeebb1cs。1、生成 有 - 的格式： 56b48f51-add0-11ed-9963-fa173e8e8ca0。2、生成不含 - 的格式：8ada3ef8add011ed9963fa173e8e8ca0。5、生成8位的随机ID。
mysql、excel生成uuid格式总结
一起码代码
04-22 4570
Mysql 1、生成 有 - 的格式： e3d7387a-c1df-11ec-ac0a-525400625d29 select UUID() as uuid 2.生成不含 - 的格式：1dd13e56c1e011ecac0a525400625d29 select replace(uuid(),"-","") as uuid; 3.insert 使用 INSERT INTO t_table (`id`,`name`) VALUES (REPLACE(UUID(),"-",""),'张三'); Ex
Excel 生成 guid uuid
The Home Of Salt Fish
04-29 1393
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)),DEC2H...
EXCEL生成uuid
09-02
在Excel中生成UUID的方法有以下几种: 1. 生成带有横杠的格式：使用以下公式：=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＊＊＊DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4))) 2. 生成去除横杠的格式：使用以下公式：=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. 直接生成带有横杠的格式：使用以下公式：=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. 直接生成去除横杠的格式：使用以下公式：=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)) <span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* [mysql、excel生成uuid格式总结](https://blog.csdn.net/weixin_43423864/article/details/124338402)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] - *2* *3* [Excel生成Guid（UUID）常用格式](https://blog.csdn.net/CircleSeven/article/details/112561008)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 3
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值