How to generate guid and uuid formats with Excel
This article mainly explains "how to use Excel to generate guid, uuid format", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "how to use Excel to generate guid, uuid format" bar!
1. Excel generates guid,uuid format: 600d65bc-948a-1260-2217-fd8dfeebb1cd
= LOWER (CONCATENATE (DEC2HEX (RANDBETWEEN (0quotation power (168)), 8), "-", DEC2HEX (RANDBETWEEN (0Power4), 4), "-", "4", DEC2HEX (RANDBETWEEN (0Power3), 3), "-", DEC2HEX (RANDBETWEEN (8p11)), DEC2HEX (RANDBETWEEN (0Power3), 3), "-", DEC2HEX (RANDBETWEEN (0pari power (168)), 8), DEC2HEX (RANDBETWEEN (0PMPOWER (16PM4), 4)
2. Excel generates guid,uuid format: 600d65bc948a12602217fd8dfeebb1cd
= LOWER (CONCATENATE (RANDBETWEEN (0charge power (168)), 8), ",", DEC2HEX (RANDBETWEEN (0Power4)), 4), "4", DEC2HEX (RANDBETWEEN (0Power3), 3), ",", DEC2HEX (RANDBETWEEN (11)), DEC2HEX (RANDBETWEEN (0Power3)), 3), ",", DEC2HEX (RANDBETWEEN (0charge power (168)), 8), DEC2HEX (RANDBETWEEN (0ler power (164)), 4))
3. Excel generates guid,uuid format: 4E3B14BB-ECF3-7B2E-A5A2-FE6E1A52DE6A
= CONCATENATE (DEC2HEX (RANDBETWEEN (0Power16)), 8), "-", DEC2HEX (RANDBETWEEN (0Power16)), 4), "-", "4", DEC2HEX (RANDBETWEEN (0Power16) 3), 3), "-", DEC2HEX (RANDBETWEEN (8page11)), DEC2HEX (RANDBETWEEN (0pint power (16pr 3)), 3), "-", DEC2HEX (RANDBETWEEN (0pr power (168)), 8), DEC2HEX (RANDBETWEEN (0Power4)), 4)
4. Excel generates guid,uuid format: 4E3B14BBECF37B2E-A5A2FE6E1A52DE6A
= CONCATENATE (DEC2HEX (RANDBETWEEN (0Power16)), 8), ",", DEC2HEX (RANDBETWEEN (0menPower4)), 4), "4", DEC2HEX (RANDBETWEEN (0Power3), 3), ",", DEC2HEX (RANDBETWEEN (811)), DEC2HEX (RANDBETWEEN (0pension3), 3), ",", DEC2HEX (RANDBETWEEN (0st power (168,8)), 8), DEC2HEX (RANDBETWEEN (0jinPower4), 4)), thank you for your reading. The above is "how to use Excel to generate guid, uuid format" content, after the study of this article, I believe we have a deeper understanding of how to use Excel to generate guid, uuid format, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!
