Isi saja n nya dengan angka yang besar. On Sun, Sep 6, 2015 at 6:18 PM, Samsudin [email protected] [belajar-excel] <[email protected]> wrote:
> > > 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 [email protected] [belajar-excel]" < > [email protected]> 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 [email protected] [belajar-excel]" < > [email protected]> 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 [email protected] [belajar-excel]" < >> [email protected]> >> Tanggal: 06/09/2015 15:36 (GMT+08:00) >> Ke: [email protected] >> Subjek: Re: [belajar-excel] Menghilangkan angka 00 >> >> >> >> Coba pake fungsi Mid pak. >> >> Salam, >> HK >> >> >> Sent from Samsung Mobile >> >> >> -------- Original message -------- >> From: "Samsudin [email protected] [belajar-excel]" >> Date:06/09/2015 12:41 (GMT+07:00) >> To: [email protected] >> 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. > > >
