Senin, 07 September 2015

[belajar-excel] Digest Number 3559

5 Messages

Digest #3559

Messages

Sun Sep 6, 2015 2:55 am (PDT) . Posted by:

"Samsudin"

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 hendrikkarnadi@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 samsudin@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.

Sun Sep 6, 2015 2:59 am (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

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 samsudin@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 hendrikkarnadi@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 samsudin@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.
>
>
>

Sun Sep 6, 2015 3:46 am (PDT) . Posted by:

"halak hita"

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 samsudin@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 hendrikkarnadi@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 samsudin@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.
>
>
>

Sun Sep 6, 2015 4:23 am (PDT) . Posted by:

"Samsudin"

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 halakhita1983@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 samsudin@bayan.com.sg<mailto:samsudin@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 hendrikkarnadi@yahoo.com<mailto:hendrikkarnadi@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 samsudin@bayan.com.sg<mailto:samsudin@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.

Sun Sep 6, 2015 4:41 am (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Isi saja n nya dengan angka yang besar.

On Sun, Sep 6, 2015 at 6:18 PM, Samsudin samsudin@bayan.com.sg
[belajar-excel] <belajar-excel@yahoogroups.com> 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 halakhita1983@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 samsudin@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 hendrikkarnadi@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 samsudin@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.
>>
>> ----------------------------------------------------------
>
> 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.
>
>
>
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar