Pakai power query ya... biar seru On Wed, Feb 12, 2020 at 4:45 PM odong nando <odongna...@gmail.com> 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 milis-belajar-excel+unsubscr...@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 > <https://groups.google.com/d/msgid/milis-belajar-excel/CAGZ5tN7kNJSR0WArepmC6O_tdv2gZ8pmD%3Doj3aR-Xkym%3D3GX5Q%40mail.gmail.com?utm_medium=email&utm_source=footer> > . >
pq_acak.xlsx
Description: MS-Excel 2007 spreadsheet