Pak Gunadi; Coba begini:
=MID(K7,FIND(1,K7,1),FIND("_",K7,1)-FIND(1,K7,1))
Copas kebawah
Wassalam
~ Bagus ~
----- Original Message -----
From: gunadi mardiono [email protected] [belajar-excel]
To: [email protected]
Sent: Tuesday, October 28, 2014 3:53 PM
Subject: [belajar-excel] mencari rumus [1 Attachment]
Dear All
Bagaimana cara mendapatkan nilai "16STA023" pada data diatas.?
Thanks
Gunadi mardiono
