EXCEL FEED: Re: [belajar-excel] Re: MODERATE -- halakhita1983@gmail.com posted to belajar-excel

Sabtu, 11 Januari 2020

Re: [belajar-excel] Re: MODERATE -- halakhita1983@gmail.com posted to belajar-excel

coba fungsi kombinasi

Left, Len , Find dan Right.

Salam,

On Sat, Jan 11, 2020 at 20:05, halak hita halakhita1983@gmail.com [belajar-excel]
<belajar-excel@yahoogroups.com> wrote:

Terima kasih mr.kid
Namun bagaimana FORMULA nya jika text di PN tidak standar atau tidak selalu 15 sebelum tanda "-".
Sebab PN ini bervariasi jumlah karakternya..

Misalnya

SC12345-R1-MAUL
RT1234-R1-MOD
V0123456789-WEW
V123456-MAUL
ZA636721-1-MODE
ZA7200891600-R2-DEL
R123456778901-R10-SAZH
A0003195008-REN
ZA6443800702-ZR
78008002400-ERT
8000A2200-01-DT

Bagaimana Formulanya agar PN bisa diambil sebelum tanda "-" terakhir

Hasil yg diinginkan
SC12345-R1
78008002400
800A2200-01

Pada tanggal Kam, 9 Jan 2020 18:33, 'Mr. Kid' mr.nmkid@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

PN= Left( teks , 15 )
Brand= Mid( teks , 17 , 99 )

On Thu, Jan 9, 2020 at 12:01 AM Mr. Kid <mr.nmkid@gmail.com> wrote:

---------- Forwarded message ---------
From: Yahoo Groups Notification <belajar-excel-accept-wybdwi1lka1fbycp34m0j02jlkrq@yahoogroups.com>
Date: Wed, Jan 8, 2020 at 9:32 AM
Subject: MODERATE -- halakhita1983@gmail.com posted to belajar-excel
To: <belajar-excel-owner@yahoogroups.com>

Hello,

A message has been sent to the belajar-excel group from

halakhita1983@gmail.com

A complete copy of this message has been attached for your convenience.

---------- Forwarded message ----------
From: halak hita <halakhita1983@gmail.com>
To: belajar-excel@yahoogroups.com
Cc:
Bcc:
Date: Wed, 8 Jan 2020 09:31:35 +0700
Subject: Formula pemisahan code
Dear master excel
Tolong dibantu apa formula ambil code id seperti terlampir.

Terima kasih

Halkit

__._,_.___

Posted by: hendrik karnadi <hendrikkarnadi@yahoo.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

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

Visit Your Group