Membuang 00 di awal berarti mengambil tengah teks. Itu sebabnya disarankan pakai Mid.
*Syntax* *MID*(*text*,*start_num*,*num_chars*) *Text* is the text string containing the characters you want to extract. *Start_num* is the position of the first character you want to extract in text. The first character in text has start_num 1, and so on. *Num_chars* specifies the number of characters you want MID to return from text. *Num_bytes* specifies the number of characters you want MIDB to return from text, in bytes. *Remarks* - If start_num is greater than the length of text, MID returns "" (empty text). - If start_num is less than the length of text, but start_num plus num_chars exceeds the length of text, MID returns the characters up to the end of text. - If start_num is less than 1, MID returns the #VALUE! error value. - If num_chars is negative, MID returns the #VALUE! error value. 1 2 A Data Fluid Flow <- contoh data Formula Description (Result) =MID(A2,1,5) Five characters from the string above, starting at the first character (Fluid) =MID(A2,7,20) Twenty characters from the string above, starting at the seventh (Flow) =MID(A2,20,5) Because the starting point is greater than the length of the string, empty text is returned () Wassalam, Kid On Sun, Sep 6, 2015 at 3:19 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. > > >
