Dear Agus, bisa coba formula “coba” / if: =IF(LEN(C3),IF(LEFT(C3)="D","D",IF(LEFT(C3,2)="FG","M","H"))&RIGHT(B3),"")
blessings, tomz From: Agus Suyanto Sent: Thursday, October 17, 2013 12:08 PM To: [email protected] Subject: ]] XL-mania [[ Jenis pekerjaan dan statusnya [1 Attachment] Dear Pakar Excell, Mohon bantuannya untuk kasus jenis pekerjaan dan statusnya berikut ini (file terlampir). Terima kasih atas bantuannya Regards, Agus Suyanto
