Maaf kalo salah kategori.
Saya mau generate 4 digit alphanumeric,
Contoh :
0001
0002
....
....
Z001
....
ZZZZ
Bagaimana formula nya.
Tks before.
Maaf kalo salah kategori.
Saya mau generate 4 digit alphanumeric,
Contoh :
0001
0002
....
....
Z001
....
ZZZZ
Bagaimana formula nya.
Tks before.
=CHAR(RANDBETWEEN(65,90))&ROUND(RAND()*999,0) alphanumeric
=ROUND(RAND()*9999,0) numeric
="Z"&ROUND(RAND()*999,0) apha("Z" char) + numeric
semoga membantu