Random otomatis text dan angka

13 views

Skip to first unread message

odong nando

unread,

Feb 12, 2020, 4:45:13 AM2/12/20

to milis-bel...@googlegroups.com

Hai member bexcel,

Mohon pencerahan utk mendapatkan data secara acak 10 karakter bisa berbentuk huruf dan angka secara acak...

Contoh hasil :

a1dfg7844g

12tykl78gf

gjak12899q

....

dst

Hasilnya huruf & angka bisa berada di karakter mana saja dalam 1 cell, dan tidak boleh sama saat saya copas ke cell yg lain...

Trimakasih...

Mr. Kid

unread,

Feb 15, 2020, 4:11:45 PM2/15/20

to odong nando, milis Belajar-Excel, BeExcel

Pakai power query ya...

biar seru

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to milis-belajar-e...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAGZ5tN7kNJSR0WArepmC6O_tdv2gZ8pmD%3Doj3aR-Xkym%3D3GX5Q%40mail.gmail.com.