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

Attachment: pq_acak.xlsx
Description: MS-Excel 2007 spreadsheet

Kirim email ke