Dear Niky;
Coba formula berikut:
=IF(RIGHT(A4,6)<>"IA.PDF",MID(A4,FIND("CASR",A4),LEN(A4)-FIND("CASR",A4)-(LEN(A4)-FIND("ID",A4)-2)),MID(A4,FIND("CASR",A4),LEN(A4)-FIND("CASR",A4)-(LEN(A4)-FIND("IA",A4)-2)))
Copy kebawah
Bagus
Sent from my Taxiphone®
----- Original Message -----
From: [email protected]
To: [email protected]
Sent: Tuesday, May 29, 2012 5:23 PM
Subject: [belajar-excel] Mengambil kode surat
Dear Para Master,
Mohon bantuannya, bagaimana caranya mengambil kode surat dari kolom "Kode
surat lengkap" menjadi seperti di kolom "Kode surat sederhana"?
Dengan persyaratan seperti data terlampir.
Terima kasih,
Niky N
