Dear Pak HK Saya sudah coba dengan formula yang didapat ternyata PO nya sangat bervariasi
CIPEUCANG/PO17000027609 WP0000008631 CIPEUCANG/PO17000035540 CIPEUCANG/PO17000039511 PO 2017/03/011/JMB 31MARET PO 2017/03/012/JMB 15 APRIL PO 2017/03/013/JMB 05 MEI CIPEUCANG/PO17000043613 0399.01213.01365/MALANG 0399.01213.01366/MALANG 18/SMP/03/C/17 AWAL MEI 1032620-100156/BANDUNG 04/SMP/03/C/17 AKHIR APRIL PMPS/SOETA/DLX/16.03.2017,B 18/SMP/03/C/17 AWAL MEI 18/SMP/03/C/17 AWAL MEI PO 2017/03/011/JMB 31MARET PO 2017/03/012/JMB 15 APRIL PO 2017/03/011/JMB 31MARET BSP000005376 1032621-100156/BOGOR PMPS/SOETA/DLX/16.03.2017,B 18/SMP/03/C/17 AWAL MEI 04/SMP/03/C/17 AKHIR APRIL PO 2017/03/011/JMB 31MARET PO 2017/03/012/JMB 15 APRIL PO 2017/03/013/JMB 05 MEI 0399.01213.01368/SIDOARJO Terima Kasih Matzen From: [email protected] [mailto:[email protected]] Sent: 28 Maret 2017 17:59 To: [email protected] Subject: Re: [belajar-excel] Ambil nama Bulan [1 Attachment] Hai Matzen, Coba =TRIM(MID(A1,FIND("JMB",A1)+6,20)) Salam, HK ________________________________ From: "'Matzen, M. (Matzen)' [email protected]<mailto:[email protected]> [belajar-excel]" <[email protected]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Sent: Tuesday, 28 March 2017, 16:33 Subject: [belajar-excel] Ambil nama Bulan Dear master Saya ada process buat PO, tapi mengalami kendala untuk ambil nama bulan nya saja, exceller punya pengalaman dengan hal ini [cid:[email protected]] Terima Kasih Matzen ____________________________________________________________________________ This email has been scanned by AkzoNobel for Viruses and Spam. For more information please contact your local IT Service Desk. ____________________________________________________________________________
