Generating random Ethereum wallet addresses

[jpowell79]

Hi guys,

Am looking for a way to generate a column of completely random Ethereum wallet addresses.

Each wallet address always begins with “0x” followed by 40 hex characters (0-9 a-f)

So a valid address might be:
0x6f1d841afce211deead45e6109895c20f8ee92f0

Am looking for a formula where I can basically just create as many of these random addresses as I need.

Any suggestions or solutions would be greatly appreciated!

Thanks

 

[lrobbo314]

What version of Excel are you on?

Does this work? Excel 365.

Book1
	A
5	0x05b02a3f0b3503620503570d80099842669fabba
6	0x20c7674a2ae3300fa3dc3ee29bc5d24061d947ff
7	0xf3de651799497ba4559769a3f106261747dad9bb
8	0x2b5ffc3038be506798dbfe83a5257fa5754d084f
9	0xbf53a4c2dde316a08af3de3bad71239a8a8b42f3
10	0xfc0b53d79c64ffc61119b93c80a30915ce6d0d5d
11	0x6b33f6b383cfab93dde24f13f1efee1243395ff2
12	0x9062a69873f3b90da37cf61ec3326b80e2fab099
13	0xeb80a24b7ca27fe773d2f24ea73ea9e224b4f5b3
14	0xa31554ab000dc734c4c0188960b32f52678665cb
15	0x30adb50731f71a4d7bbfa1ee212cb732221c99f2
16	0xfdfd35f930dcbab17d3ae6320d3801cf39ef8c1d
17	0xf141c53677a3780a8795fc3e317262610b4dc3f4
18	0x62419dbad979bee472533916e37ab06c63cd947d
19	0xd77be700951c1e80271f746e9f85328d5a664830
20	0x5b9be0037c24ea879827d0dda80daa37191d66ee
21	0xa0a135534ac85963ccb51e7556abc5a56cf5470e
22	0x0a3bb18f7fe3bf19e19e0869716573079df81058
23	0xfc0b1e5a48d066df6cab4582e146000b53aab739
24	0x4a8dca798841206c4bbc1e01b9fe26181707af98
25	0x718056eb5d2144112c69542d4f58706bc0edf989
26	0x2cad90f7888da74fff3c4023e803c7b395f3376f
27	0x8f7870c7b6ab20bf1e588fbe0d4887c6f8845c13
28	0xd6bd4fba605b1e3802c04f81bef542b5473e52d0
29	0xcc73eadb8a7f89e8120f8c6406d7a78d00c41353
30	0x174ec99a3072ea841a0f1ab34f91a4188b86e3d8
31	0x7e7c68fdd1941a7d95d9cd6147f26186efb31a40
32	0x276f9636329527392a7a782cd7d86ea12997fc96
33	0xbe94eab8bc8615b5a0e7ab1f3d52c12ce605c481
34	0xd84285e360f1e906e9ac48c773dc3a53e04413d2
35	0x895c7a6f90ac6810197cd740ae152b61d3681f45
Sheet1

Cell Formulas
Range	Formula
A5:A35	A5	="0x" & TEXTJOIN("",1,MID("0123456789abcdef",RANDARRAY(40,,1,16,1),1))

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Another option for 365 or 2021

=CONCAT("0x",BASE(RANDARRAY(40,,0,15,1),16,1))

 

[Rick Rothstein]

This should also work...

=CONCAT("0x",DEC2HEX(RANDARRAY(40,,1,16,1)))

If you need the letters to be lower case, then use this instead...

=LOWER(CONCAT("0x",DEC2HEX(RANDARRAY(40,,1,16,1))))

 

[jpowell79]

thanks guys much appreciated. I couldn't get them to work, so am assuming it's because I'm running Office 2016? Do I need to upgrade?

 

[jpowell79]

just upgraded to Office 2021 and now works like a charm!! thanks guys very much appreciated!

 

[Fluff]

just upgraded to Office 2021

Please update you account details as requested, so that members know in the future.

now works like a charm!!

Glad we could help & thanks for the feedback.

 

[cryptosaver]

What version of Excel are you on?

Does this work? Excel 365.

Book1
	A
5	0x05b02a3f0b3503620503570d80099842669fabba
6	0x20c7674a2ae3300fa3dc3ee29bc5d24061d947ff
7	0xf3de651799497ba4559769a3f106261747dad9bb
8	0x2b5ffc3038be506798dbfe83a5257fa5754d084f
9	0xbf53a4c2dde316a08af3de3bad71239a8a8b42f3
10	0xfc0b53d79c64ffc61119b93c80a30915ce6d0d5d
11	0x6b33f6b383cfab93dde24f13f1efee1243395ff2
12	0x9062a69873f3b90da37cf61ec3326b80e2fab099
13	0xeb80a24b7ca27fe773d2f24ea73ea9e224b4f5b3
14	0xa31554ab000dc734c4c0188960b32f52678665cb
15	0x30adb50731f71a4d7bbfa1ee212cb732221c99f2
16	0xfdfd35f930dcbab17d3ae6320d3801cf39ef8c1d
17	0xf141c53677a3780a8795fc3e317262610b4dc3f4
18	0x62419dbad979bee472533916e37ab06c63cd947d
19	0xd77be700951c1e80271f746e9f85328d5a664830
20	0x5b9be0037c24ea879827d0dda80daa37191d66ee
21	0xa0a135534ac85963ccb51e7556abc5a56cf5470e
22	0x0a3bb18f7fe3bf19e19e0869716573079df81058
23	0xfc0b1e5a48d066df6cab4582e146000b53aab739
24	0x4a8dca798841206c4bbc1e01b9fe26181707af98
25	0x718056eb5d2144112c69542d4f58706bc0edf989
26	0x2cad90f7888da74fff3c4023e803c7b395f3376f
27	0x8f7870c7b6ab20bf1e588fbe0d4887c6f8845c13
28	0xd6bd4fba605b1e3802c04f81bef542b5473e52d0
29	0xcc73eadb8a7f89e8120f8c6406d7a78d00c41353
30	0x174ec99a3072ea841a0f1ab34f91a4188b86e3d8
31	0x7e7c68fdd1941a7d95d9cd6147f26186efb31a40
32	0x276f9636329527392a7a782cd7d86ea12997fc96
33	0xbe94eab8bc8615b5a0e7ab1f3d52c12ce605c481
34	0xd84285e360f1e906e9ac48c773dc3a53e04413d2
35	0x895c7a6f90ac6810197cd740ae152b61d3681f45
Sheet1

Cell Formulas
Range	Formula
A5:A35	A5	="0x" & TEXTJOIN("",1,MID("0123456789abcdef",RANDARRAY(40,,1,16,1),1))

can I see the example of this? I tried to copy just the formula, I don't know what to put in cells in order to work.