Generate random 6-16-byte random hexadecimal number

**jsamuelshn** · 09-20-2010, 05:51 PM

Hello,

Is it possible for Excel to generate random 16-byte hexadecimal numbers that would not be repeated? Also, would I be able to select how many bytes I need the random number to be...selectable from 6-16? I most likely only need 16-byte, but just in case I want a smaller passcodes.

If not, does anyone know of a program that will do it easily?

Thank you!

**shg** · 09-20-2010, 06:05 PM

= DEC2HEX(RANDBETWEEN(0, 2^16), 4)
& DEC2HEX(RANDBETWEEN(0, 2^16), 4)
& DEC2HEX(RANDBETWEEN(0, 2^16), 4)
& DEC2HEX(RANDBETWEEN(0, 2^16), 4)
& DEC2HEX(RANDBETWEEN(0, 2^16), 4)
& DEC2HEX(RANDBETWEEN(0, 2^16), 4)
& DEC2HEX(RANDBETWEEN(0, 2^16), 4)
& DEC2HEX(RANDBETWEEN(0, 2^16), 4)

Each one adds two bytes.

**jsamuelshn** · 09-20-2010, 07:54 PM

Thank you shg!

Does this only work on version 2007? I tried inputting this formula in my 2003 Excel and I just get #NAME in the box. What does the ,4 mean?

Thanks again!

**shg** · 09-20-2010, 07:56 PM

Pre 2007, Tools > Add-Ins, tick Analysis Toolpak

After you get that working, post back if Help doesn't answer your other question.

**jsamuelshn** · 09-20-2010, 08:13 PM

Thanks again shg!

That works perfectly.

**shg** · 07-20-2012, 09:52 AM

That should be ...

= DEC2HEX(RANDBETWEEN(0, 2^16 - 1), 4)
& DEC2HEX(RANDBETWEEN(0, 2^16 - 1), 4)
& DEC2HEX(RANDBETWEEN(0, 2^16 - 1), 4)
& DEC2HEX(RANDBETWEEN(0, 2^16 - 1), 4)
& DEC2HEX(RANDBETWEEN(0, 2^16 - 1), 4)
& DEC2HEX(RANDBETWEEN(0, 2^16 - 1), 4)
& DEC2HEX(RANDBETWEEN(0, 2^16 - 1), 4)
& DEC2HEX(RANDBETWEEN(0, 2^16 - 1), 4)

... or

= DEC2HEX(RANDBETWEEN(0, 2^32 - 1), 8)
& DEC2HEX(RANDBETWEEN(0, 2^32 - 1), 8)
& DEC2HEX(RANDBETWEEN(0, 2^32 - 1), 8)
& DEC2HEX(RANDBETWEEN(0, 2^32 - 1), 8)