Contoh
A. B
1. Makan
2
=mid(A1,2,4)
Hasil = akan
A1 letak kata
1. Huruf yang kita ambil atau dimulai dari
2. Jumlah huruf yang diambil
Dikirim dari telepon pintar vivo saya
"'Matzen, M. (Matzen)' [email protected] [belajar-excel]"
<[email protected]> menulis:
>
>Dear Mr.Kid
>
>Untuk menentuka karakter ke berapa dan jumlah karakter yang akan di ambilnya
>nya gimana ? bukan kah datanya bervariasi
>
>Terima Kasih
>
>Matzen
>
>From: [email protected] [mailto:[email protected]]
>Sent: 28 Maret 2017 17:05
>To: [email protected]
>Subject: Re: [belajar-excel] Ambil nama Bulan
>
>
>Hai Matzen,
>
>Coba pakai Fungsi Mid
>Regards,
>Kid
>Sent from my smart enough phone
>
>On Mar 28, 2017, at 16:33, 'Matzen, M. (Matzen)' [email protected]
>[belajar-excel] <[email protected]> wrote:
>
>Dear master
>
>Saya ada process buat PO, tapi mengalami kendala untuk ambil nama bulan nya
>saja, exceller punya pengalaman dengan hal ini
>
><image001.png>
>
>Terima Kasih
>
>Matzen
>
>
>____________________________________________________________________________
>This email has been scanned by AkzoNobel for Viruses and Spam.
>For more information please contact your local IT Service Desk.
>____________________________________________________________________________
>
>_____________________________________________
>Posted by: "Matzen, M. (Matzen)" <[email protected]>
>_____________________________________________
>Reply via web post • Reply to sender • Reply to group • Start a New Topic •
>Messages in this topic (3)
>_____________________________________________
>
>
>Have you tried the highest rated email app?
>With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on
>the market. What are you waiting for? Now you can access all your inboxes
>(Gmail, Outlook, AOL and more) in one place. Never delete an email again with
>1000GB of free cloud storage.
>_____________________________________________
>============================================================
>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:
>[email protected]
>posting ke milis, kirimkan ke: [email protected]
>berkunjung ke web milis :
>http://tech.groups.yahoo.com/group/belajar-excel/messages
>melihat file archive / mendownload lampiran :
>http://www.mail-archive.com/[email protected]/
>atau (sejak 25-Apr-2011) bisa juga di :
>http://milis-belajar-excel.1048464.n5.nabble.com/
>menghubungi moderators & owners: [email protected]
>keluar dari membership milis (UnSubscribe), kirim mail kosong ke :
>[email protected]
>---------------------------------------------------------------------
