[milis-belajar-excel] Random otomatis text dan angka

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[milis-belajar-excel] Random otomatis text dan angka

odong nando
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...

--
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 [hidden email].
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.
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Random otomatis text dan angka

Kid
Administrator
Pakai power query ya...
biar seru

On Wed, Feb 12, 2020 at 4:45 PM odong nando <[hidden email]> wrote:
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...

--
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 [hidden email].
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.

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPvVtD%2BEBzAE55vcOoA1dC8zEBg%2B%3DssbEhvG%2BqX0ZyRdVQ%40mail.gmail.com.

pq_acak.xlsx (47K) Download Attachment