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 [belajar-excel]" < 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 [belajar-excel]" < > belajar-excel@yahoogroups.com> > Tanggal: 06/09/2015 15:36 (GMT+08:00) > Ke: 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 [belajar-excel]" > Date:06/09/2015 12:41 (GMT+07:00) > To: 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. > > >