@rizald: tau aja nih, kalo itu npwp.. Tolong bantu formula lengkapnya dong, kan gak cuma "=substitute" aja.. Tq
-----Original Message----- From: rizald al kaaf <[email protected]> Date: Wed, 10 Aug 2011 10:59:25 pasti NPWP nih pake rumus "=substitute" saja On 8/10/11, [email protected] <[email protected]> wrote: > Dear master Ex-cel, salam kenal.. > Mohon bantuan pd master excel semua, > Langsung pd kasusnya, > > Misalkan di cell A1 terdapat data angka sebagai berikut: > 12.345.678.9-123.456 > > Nah, apa fungsi excel yang paling sederhana untuk menghilangkan tanda "." dan > tanda "-" pd A1 tersebut. > > Catatan: hasil yang diinginkan bukan bilangan, tapi menjadi angka seperti > ini: 123456789123456. > > Terima kasih sebelumnya pada master excel smua yang telah membatu. > Salam-Iskandar =============================== mod note: footernya di buang dulu dong (sudah dibuang oleh mods) =============================== ------------------------------------ --------------------------------------------------------------------- bergabung ke milis (subscribe), kirim mail kosong ke: [email protected] posting ke milis, kirimkan ke: [email protected] berkunjung ke web milis http://tech.groups.yahoo.com/group/belajar-excel/messages melihat file archive / mendownload lampiran http://www.mail-archive.com/[email protected]/ atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/ menghubungi moderators & owners: [email protected] keluar dari membership milis (UnSubscribe): kirim mail kosong ke [email protected] ---------------------------------------------------------------------Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-excel/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-excel/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
