msubel/uuid_v4_excel_formula.txt

andrescollao · 2018-09-06T16:50:01Z

The Spanish version for Excel 2018:

=MINUSC(CONCATENAR(DEC.A.HEX(ALEATORIO.ENTRE(0;POTENCIA(16;8));8);"-";DEC.A.HEX(ALEATORIO.ENTRE(0;POTENCIA(16;4));4);"-";"4";DEC.A.HEX(ALEATORIO.ENTRE(0;POTENCIA(16;3));3);"-";DEC.A.HEX(ALEATORIO.ENTRE(8;11));DEC.A.HEX(ALEATORIO.ENTRE(0;POTENCIA(16;3));3);"-";DEC.A.HEX(ALEATORIO.ENTRE(0;POTENCIA(16;8));8);DEC.A.HEX(ALEATORIO.ENTRE(0;POTENCIA(16;4));4)))

Note: Consider your regional configuration, maybe it will be a necessary change from ; to ,

qacpiweb · 2018-09-07T07:49:39Z

Polish version with "|"

=LITERY.MAŁE(ZŁĄCZ.TEKSTY(DZIES.NA.SZESN(LOS.ZAKR(0|POTĘGA(16|8))|8)|"-"|DZIES.NA.SZESN(LOS.ZAKR(0|POTĘGA(16|4))|4)|"-"|"4"|DZIES.NA.SZESN(LOS.ZAKR(0|POTĘGA(16|3))|3)|"-"|DZIES.NA.SZESN(LOS.ZAKR(8|11))|DZIES.NA.SZESN(LOS.ZAKR(0|POTĘGA(16|3))|3)|"-"|DZIES.NA.SZESN(LOS.ZAKR(0|POTĘGA(16|8))|8)|DZIES.NA.SZESN(LOS.ZAKR(0|POTĘGA(16|4))|4)))

degiorgig · 2018-10-23T14:53:43Z

In Italian:

=MINUSC(CONCATENA(DECIMALE.HEX(CASUALE.TRA(0;POTENZA(16;8));8);"-";DECIMALE.HEX(CASUALE.TRA(0;POTENZA(16;4));4);"-";"4";DECIMALE.HEX(CASUALE.TRA(0;POTENZA(16;3));3);"-";DECIMALE.HEX(CASUALE.TRA(8;11));DECIMALE.HEX(CASUALE.TRA(0;POTENZA(16;3));3);"-";DECIMALE.HEX(CASUALE.TRA(0;POTENZA(16;8));8);DECIMALE.HEX(CASUALE.TRA(0;POTENZA(16;4));4)))

denis-roy · 2018-11-12T19:30:53Z

French one-liner:

=MINUSCULE(CONCATENER(DECHEX(ALEA.ENTRE.BORNES(0;PUISSANCE(16;8));8);"-";DECHEX(ALEA.ENTRE.BORNES(0;PUISSANCE(16;4));4);"-";"4";DECHEX(ALEA.ENTRE.BORNES(0;PUISSANCE(16;3));3);"-";DECHEX(ALEA.ENTRE.BORNES(8;11));DECHEX(ALEA.ENTRE.BORNES(0;PUISSANCE(16;3));3);"-";DECHEX(ALEA.ENTRE.BORNES(0;PUISSANCE(16;8));8);DECHEX(ALEA.ENTRE.BORNES(0;PUISSANCE(16;4));4)))

Indented for readability:

=MINUSCULE(
    CONCATENER(
        DECHEX(ALEA.ENTRE.BORNES(0; PUISSANCE(16; 8)); 8); 
        "-"; 
        DECHEX(ALEA.ENTRE.BORNES(0; PUISSANCE(16;4)); 4); 
        "-"; 
        "4"; 
        DECHEX(ALEA.ENTRE.BORNES(0; PUISSANCE(16; 3)); 3); 
        "-"; 
        DECHEX(ALEA.ENTRE.BORNES(8; 11));
        DECHEX(ALEA.ENTRE.BORNES(0; PUISSANCE(16; 3)); 3); 
        "-"; 
        DECHEX(ALEA.ENTRE.BORNES(0; PUISSANCE(16; 8)); 8); 
        DECHEX(ALEA.ENTRE.BORNES(0; PUISSANCE(16; 4)); 4)
    )
)

Other languages available through this Excel translator website

oralzb · 2019-01-09T12:10:04Z

in Russian
=СТРОЧН(СЦЕПИТЬ(ДЕС.В.ШЕСТН(СЛУЧМЕЖДУ(0;СТЕПЕНЬ(16;8));8);"-";ДЕС.В.ШЕСТН(СЛУЧМЕЖДУ(0;СТЕПЕНЬ(16;4));4);"-";"4";ДЕС.В.ШЕСТН(СЛУЧМЕЖДУ(0;СТЕПЕНЬ(16;3));3);"-";ДЕС.В.ШЕСТН(СЛУЧМЕЖДУ(8;11));ДЕС.В.ШЕСТН(СЛУЧМЕЖДУ(0;СТЕПЕНЬ(16;3));3);"-";ДЕС.В.ШЕСТН(СЛУЧМЕЖДУ(0;СТЕПЕНЬ(16;8));8);ДЕС.В.ШЕСТН(СЛУЧМЕЖДУ(0;СТЕПЕНЬ(16;4));4)))

f2l2pe · 2019-04-30T15:19:00Z

In Portuguese Brasil
=MINÚSCULA(CONCATENAR(DECAHEX(ALEATÓRIOENTRE(0;POTÊNCIA(16;8));8);"-";DECAHEX(ALEATÓRIOENTRE(0;POTÊNCIA(16;4));4);"-";"4";DECAHEX(ALEATÓRIOENTRE(0;POTÊNCIA(16;3));3);"-";DECAHEX(ALEATÓRIOENTRE(8;11));DECAHEX(ALEATÓRIOENTRE(0;POTÊNCIA(16;3));3);"-";DECAHEX(ALEATÓRIOENTRE(0;POTÊNCIA(16;8));8);DECAHEX(ALEATÓRIOENTRE(0;POTÊNCIA(16;4));4)))

meszi05 · 2019-05-22T06:56:18Z

In Hungarian:
=KISBETŰ(ÖSSZEFŰZ(DEC.HEX(VÉLETLEN.KÖZÖTT(0;HATVÁNY(16;8));8);"-";DEC.HEX(VÉLETLEN.KÖZÖTT(0;HATVÁNY(16;4));4);"-";"4";DEC.HEX(VÉLETLEN.KÖZÖTT(0;HATVÁNY(16;3));3);"-";DEC.HEX(VÉLETLEN.KÖZÖTT(8;11));DEC.HEX(VÉLETLEN.KÖZÖTT(0;HATVÁNY(16;3));3);"-";DEC.HEX(VÉLETLEN.KÖZÖTT(0;HATVÁNY(16;8));8);DEC.HEX(VÉLETLEN.KÖZÖTT(0;HATVÁNY(16;4));4)))

mpaulusma · 2019-10-30T15:31:31Z

I just need to say thank you too! Lifesaver

mcelal · 2019-11-12T19:59:12Z

In Turkish:
=KÜÇÜKHARF(BİRLEŞTİR(DEC2HEX(RASTGELEARADA(0;KUVVET(16;8));8);"-";DEC2HEX(RASTGELEARADA(0;KUVVET(16;4));4);"-";"4";DEC2HEX(RASTGELEARADA(0;KUVVET(16;3));3);"-";DEC2HEX(RASTGELEARADA(8;11));DEC2HEX(RASTGELEARADA(0;KUVVET(16;3));3);"-";DEC2HEX(RASTGELEARADA(0;KUVVET(16;8));8);DEC2HEX(RASTGELEARADA(0;KUVVET(16;4));4)))

rukayaj · 2019-12-16T11:18:25Z

It generates duplicates for large numbers of UUIDS (14 500 of them) in osx, I ran it 5 or 6 times and there were around 8 duplicates each time.

MightyMirko · 2020-02-21T09:26:20Z

Also it is recalculated everytime

nibble-4bits · 2020-04-28T03:59:50Z

Spanish Version:

=MINUSC(CONCAT(DEC.A.HEX(ALEATORIO.ENTRE(0,POTENCIA(16,8)),8),"-",DEC.A.HEX(ALEATORIO.ENTRE(0,POTENCIA(16,4)),4),"-","4",DEC.A.HEX(ALEATORIO.ENTRE(0,POTENCIA(16,3)),3),"-",DEC.A.HEX(ALEATORIO.ENTRE(8,11)),DEC.A.HEX(ALEATORIO.ENTRE(0,POTENCIA(16,3)),3),"-",DEC.A.HEX(ALEATORIO.ENTRE(0,POTENCIA(16,8)),8),DEC.A.HEX(ALEATORIO.ENTRE(0,POTENCIA(16,4)),4)))

vitalie-cracan · 2020-07-18T10:02:01Z

For within VBA:

Target.Value = _
LCase(WorksheetFunction.Concat( _
WorksheetFunction.Dec2Hex(WorksheetFunction.RandBetween(0, WorksheetFunction.Power(16, 8)), 8), _
"-", _
WorksheetFunction.Dec2Hex(WorksheetFunction.RandBetween(0, WorksheetFunction.Power(16, 4)), 4), _
"-", "4", _
WorksheetFunction.Dec2Hex(WorksheetFunction.RandBetween(0, WorksheetFunction.Power(16, 3)), 3), _
"-", _
WorksheetFunction.Dec2Hex(WorksheetFunction.RandBetween(8, 11)), _
WorksheetFunction.Dec2Hex(WorksheetFunction.RandBetween(0, WorksheetFunction.Power(16, 3)), 3), _
"-", _
WorksheetFunction.Dec2Hex(WorksheetFunction.RandBetween(0, WorksheetFunction.Power(16, 8)), 8), _
WorksheetFunction.Dec2Hex(WorksheetFunction.RandBetween(0, WorksheetFunction.Power(16, 4)), 4) _
))

4cer · 2021-08-23T14:13:44Z

Polish version with ";"
=LITERY.MAŁE(ZŁĄCZ.TEKSTY(DZIES.NA.SZESN(LOS.ZAKR(0;POTĘGA(16;8));8);"-";DZIES.NA.SZESN(LOS.ZAKR(0;POTĘGA(16;4));4);"-";"4";DZIES.NA.SZESN(LOS.ZAKR(0;POTĘGA(16;3));3);"-";DZIES.NA.SZESN(LOS.ZAKR(8;11));DZIES.NA.SZESN(LOS.ZAKR(0;POTĘGA(16;3));3);"-";DZIES.NA.SZESN(LOS.ZAKR(0;POTĘGA(16;8));8);DZIES.NA.SZESN(LOS.ZAKR(0;POTĘGA(16;4));4)))

jgalinha · 2021-12-20T13:13:06Z

in Portuguese:
=MINÚSCULAS(CONCATENAR(DECAHEX(ALEATÓRIOENTRE(0;POTÊNCIA(16;8));8);"-";DECAHEX(ALEATÓRIOENTRE(0;POTÊNCIA(16;4));4);"-";"4";DECAHEX(ALEATÓRIOENTRE(0;POTÊNCIA(16;3));3);"-";DECAHEX(ALEATÓRIOENTRE(8;11));DECAHEX(ALEATÓRIOENTRE(0;POTÊNCIA(16;3));3);"-";DECAHEX(ALEATÓRIOENTRE(0;POTÊNCIA(16;8));8);DECAHEX(ALEATÓRIOENTRE(0;POTÊNCIA(16;4));4)))

pownas · 2023-04-13T08:14:11Z

Svenska/Swedish one-liner:

=GEMENER(SAMMANFOGA(DEC.TILL.HEX(SLUMP.MELLAN(0;UPPHÖJT.TILL(16;8));8);"-";DEC.TILL.HEX(SLUMP.MELLAN(0;UPPHÖJT.TILL(16;4));4);"-";"4";DEC.TILL.HEX(SLUMP.MELLAN(0;UPPHÖJT.TILL(16;3));3);"-";DEC.TILL.HEX(SLUMP.MELLAN(8;11));DEC.TILL.HEX(SLUMP.MELLAN(0;UPPHÖJT.TILL(16;3));3);"-";DEC.TILL.HEX(SLUMP.MELLAN(0;UPPHÖJT.TILL(16;8));8);DEC.TILL.HEX(SLUMP.MELLAN(0;UPPHÖJT.TILL(16;4));4)))

Indented for readability:

=GEMENER(
  SAMMANFOGA(
    DEC.TILL.HEX(SLUMP.MELLAN(0;UPPHÖJT.TILL(16;8));8);
    "-";
    DEC.TILL.HEX(SLUMP.MELLAN(0;UPPHÖJT.TILL(16;4));4);
    "-";
    "4";
    DEC.TILL.HEX(SLUMP.MELLAN(0;UPPHÖJT.TILL(16;3));3);
    "-";
    DEC.TILL.HEX(SLUMP.MELLAN(8;11));
    DEC.TILL.HEX(SLUMP.MELLAN(0;UPPHÖJT.TILL(16;3));3);
    "-";
    DEC.TILL.HEX(SLUMP.MELLAN(0;UPPHÖJT.TILL(16;8));8);
    DEC.TILL.HEX(SLUMP.MELLAN(0;UPPHÖJT.TILL(16;4));4)
  )
)

Other languages translated on this page:
https://en.excel-translator.de/translator/

pbubar · 2023-11-28T21:58:46Z

I get #NUM! errors one in every few thousand calculations of this formula.

Here is why:

POWER(16;4) returns 65536.
RANDBETWEEN is inclusive of the 'bottom' and 'top' values.
DEC2HEX(65536;4) throws the NUM error as its needs 5 characters; the highest value DEC2HEX can return in 4 characters is 65535
So the POWER() function is giving a 'top' bound to the RANDBETWEEN that is exactly 1 too high.

The fix is to add -1 after each use of the POWER() function in the formula:

=LOWER(CONCATENATE(DEC2HEX(RANDBETWEEN(0;POWER(16;8)-1);8);"-";DEC2HEX(RANDBETWEEN(0;POWER(16;4)-1);4);"-";"4";DEC2HEX(RANDBETWEEN(0;POWER(16;3)-1);3);"-";DEC2HEX(RANDBETWEEN(8;11));DEC2HEX(RANDBETWEEN(0;POWER(16;3)-1);3);"-";DEC2HEX(RANDBETWEEN(0;POWER(16;8)-1);8);DEC2HEX(RANDBETWEEN(0;POWER(16;4)-1);4)))

JesseWStratton · 2024-03-15T21:58:48Z

Just one question... The GUID's get refreshed evertime I do something to the column or near the column that contain the formula. Is there a way to just generate it once and fix the generated GUID's?

Regards, Arie

I set one cell in excel to be my UUID generator using the formula and naming the range, then I use VBA to refer to the named range when I want to commit the value to a stored location using something like:

For Each rRecord In rNewRecords
     rRecord.Offset(0, -1).Value = [r_uuid].Value
     [r_uuid].Calculate
Next rRecord

Where r_uuid is a named range in the workbook.

CodedSpirit-dev · 2024-07-02T18:40:08Z

For Spanish-MX Excel

=MINUSC(CONCATENAR(DEC.A.HEX(ALEATORIO.ENTRE(0,POTENCIA(16,8)),8),"-",DEC.A.HEX(ALEATORIO.ENTRE(0,POTENCIA(16,4)),4),"-","4",DEC.A.HEX(ALEATORIO.ENTRE(0,POTENCIA(16,3)),3),"-",DEC.A.HEX(ALEATORIO.ENTRE(8,11)),DEC.A.HEX(ALEATORIO.ENTRE(0,POTENCIA(16,3)),3),"-",DEC.A.HEX(ALEATORIO.ENTRE(0,POTENCIA(16,8)),8),DEC.A.HEX(ALEATORIO.ENTRE(0,POTENCIA(16,4)),4)))

msubel/uuid_v4_excel_formula.txt

andrescollao commented Sep 6, 2018

qacpiweb commented Sep 7, 2018

degiorgig commented Oct 23, 2018 •

edited

Loading

denis-roy commented Nov 12, 2018

oralzb commented Jan 9, 2019 •

edited

Loading

f2l2pe commented Apr 30, 2019 •

edited

Loading

meszi05 commented May 22, 2019 •

edited

Loading

mpaulusma commented Oct 30, 2019

mcelal commented Nov 12, 2019

rukayaj commented Dec 16, 2019

MightyMirko commented Feb 21, 2020

nibble-4bits commented Apr 28, 2020

vitalie-cracan commented Jul 18, 2020

4cer commented Aug 23, 2021

jgalinha commented Dec 20, 2021

pownas commented Apr 13, 2023

pbubar commented Nov 28, 2023

JesseWStratton commented Mar 15, 2024 •

edited

Loading

CodedSpirit-dev commented Jul 2, 2024

msubel/uuid_v4_excel_formula.txt

andrescollao commented Sep 6, 2018

qacpiweb commented Sep 7, 2018

degiorgig commented Oct 23, 2018 • edited Loading

denis-roy commented Nov 12, 2018

oralzb commented Jan 9, 2019 • edited Loading

f2l2pe commented Apr 30, 2019 • edited Loading

meszi05 commented May 22, 2019 • edited Loading

mpaulusma commented Oct 30, 2019

mcelal commented Nov 12, 2019

rukayaj commented Dec 16, 2019

MightyMirko commented Feb 21, 2020

nibble-4bits commented Apr 28, 2020

vitalie-cracan commented Jul 18, 2020

4cer commented Aug 23, 2021

jgalinha commented Dec 20, 2021

pownas commented Apr 13, 2023

pbubar commented Nov 28, 2023

JesseWStratton commented Mar 15, 2024 • edited Loading

CodedSpirit-dev commented Jul 2, 2024

degiorgig commented Oct 23, 2018 •

edited

Loading

oralzb commented Jan 9, 2019 •

edited

Loading

f2l2pe commented Apr 30, 2019 •

edited

Loading

meszi05 commented May 22, 2019 •

edited

Loading

JesseWStratton commented Mar 15, 2024 •

edited

Loading