Dear All, Terima kasih atas pencerahannya dan bgmn bila dibelakang 00 jumlah ada n huruf atau angka atau nomor
Terkirim dari tablet Samsung "halak hita halakhita1...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Misal cell a1 ada isi nya spt ; 00chp Maka jika yng diambil adalah chp nya maka dapat dibuat rumusnya misalnya di cell b2 dapat dibuat rumus nya sot berikut =MID(A1,3,3) hasilnya akan menjadi: CHP On Sep 6, 2015 4:55 PM, "Samsudin samsu...@bayan.com.sg<mailto:samsu...@bayan.com.sg> [belajar-excel]" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>> wrote: Terima kasih Pak Hendrik Tetapi yg saya inginkan angka atau huruf dibelakang 00 tetap digunakan. Hormat saya, Samsudin Dikirim dari perangkat Samsung E7 saya -------- Pesan asli -------- Dari: "Hendrik Karnadi hendrikkarn...@yahoo.com<mailto:hendrikkarn...@yahoo.com> [belajar-excel]" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>> Tanggal: 06/09/2015 15:36 (GMT+08:00) Ke: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com> Subjek: Re: [belajar-excel] Menghilangkan angka 00 Coba pake fungsi Mid pak. Salam, HK Sent from Samsung Mobile -------- Original message -------- From: "Samsudin samsu...@bayan.com.sg<mailto:samsu...@bayan.com.sg> [belajar-excel]" Date:06/09/2015 12:41 (GMT+07:00) To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com> Subject: [belajar-excel] Menghilangkan angka 00 Dear Master excel, Mohon bantuannya bagaimana caranya jika kita ingin menghilang angka 2 digit didepanya, misalnya ada data 00chp, bagaimana formulanya biar dua digit angka didepan hilang. Terima kasih. Hormat saya, Samsudin 08112810068 Dikirim dari perangkat Samsung E7 saya --------------------------------------------------------------------------------------------------- This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and hereby notified that any disclosure, copying, or distribution of this message (or any part thereof), or the taking of any action based on it, is strictly prohibited. No liability or responsibility is accepted if information or data is, for whatever reason corrupted or does not reach its intended recipient. No warranty is given that this email is free of viruses. The views expressed in this email are, unless otherwise stated, those of the author and not those of the Company or its management. The Company reserves the right to monitor, intercept and block emails addressed to its users or take any other action in accordance with its email use policy. --------------------------------------------------------------------------------------------------- This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and hereby notified that any disclosure, copying, or distribution of this message (or any part thereof), or the taking of any action based on it, is strictly prohibited. No liability or responsibility is accepted if information or data is, for whatever reason corrupted or does not reach its intended recipient. No warranty is given that this email is free of viruses. The views expressed in this email are, unless otherwise stated, those of the author and not those of the Company or its management. The Company reserves the right to monitor, intercept and block emails addressed to its users or take any other action in accordance with its email use policy. --------------------------------------------------------------------------------------------------- This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and hereby notified that any disclosure, copying, or distribution of this message (or any part thereof), or the taking of any action based on it, is strictly prohibited. No liability or responsibility is accepted if information or data is, for whatever reason corrupted or does not reach its intended recipient. No warranty is given that this email is free of viruses. The views expressed in this email are, unless otherwise stated, those of the author and not those of the Company or its management. The Company reserves the right to monitor, intercept and block emails addressed to its users or take any other action in accordance with its email use policy.