Selasa, 30 Juni 2015

[belajar-excel] Digest Number 3493

2 Messages

Digest #3493

Messages

Mon Jun 29, 2015 11:41 pm (PDT) . Posted by:

"Maman"

Assalaamu'alaikum Wr. Wb.

Dear Master Excel, mohon sharing ilmunya untuk mencari Nilai Pembagi
dari file terlampir.

Terima Kasih

Tue Jun 30, 2015 1:21 am (PDT) . Posted by:

"Dede"

Dear Mr Maman,

Sambil menunggu dari Master-master yang lain, coba masukan rumus di cell B3 :

=MID(A3;FIND("/";A3)+1;9)

Kemudian lakukan langkah seperti ini :

1. Blok kolom A

2. Tekan Ctrl +F

3. Pilih Replace

a. Find What diisi =

b. Replace with diisi #

c. Replace All

d. Close

Selesai.

Salam,

DD

From: Maman superm42n@gmail.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 30 Juni 2015 13:35
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Mencari Nilai Pembagi [1 Attachment]

Assalaamu'alaikum Wr. Wb.

Dear Master Excel, mohon sharing ilmunya untuk mencari Nilai Pembagi
dari file terlampir.

Terima Kasih

_____

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.

============================================================
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:

Posting Komentar