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.nm...@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.nm...@gmail.com> wrote: > >> >> >> ---------- Forwarded message --------- >> From: Yahoo Groups Notification < >> belajar-excel-accept-wybdwi1lka1fbycp34m0j02jl...@yahoogroups.com> >> Date: Wed, Jan 8, 2020 at 9:32 AM >> Subject: MODERATE -- halakhita1...@gmail.com posted to belajar-excel >> To: <belajar-excel-ow...@yahoogroups.com> >> >> >> >> Hello, >> >> A message has been sent to the belajar-excel group from >> >> halakhita1...@gmail.com >> >> A complete copy of this message has been attached for your convenience. >> >> >> ---------- Forwarded message ---------- >> From: halak hita <halakhita1...@gmail.com> >> To: belajar-excel@yahoogroups.com <belajar-ex...@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 >> >> >