saya mo coba dgn rms :
=MID(A2;3;IF(ISERR(FIND("(";A2;3));FIND("/";A2;3);FIND("(";A2;3))-3)
terlampir yaw
Pada Selasa, 13 Mei 2014 19:32, "[email protected] [belajar-excel]"
<[email protected]> menulis:
Hai Alfan,
Saya mau coba jawab coba ketik
=TRIM(MID(SUBSTITUTE(A3, "/", "("), FIND("wo ", SUBSTITUTE(A3, "/", "("), 1)+3,
FIND("(", SUBSTITUTE(A3, "/", "("), 1)-5))
Di tempat yg kamu inginkan lalu copy ke bawah mudah2 an sesuai yg diinginkan
Powered by Telkomsel BlackBerry®
________________________________
From: "Alfan Atas Pujianto [email protected] [belajar-excel]"
<[email protected]>
Sender: [email protected]
Date: Tue, 13 May 2014 16:35:51 +0800 (SGT)
To: <[email protected]>
ReplyTo: [email protected]
Subject: [belajar-excel] RUMUS mengambil karakter ditengah [1 Attachment]
Dear All
Mohon bantuan rekan, untuk mengambil karakter nama setelah kata WO itu
praktisnya pakai rumus bagaimana? seperti contoh terlampir.
Regard
Alfan
contoh pic wo js-1.xlsx
Description: MS-Excel 2007 spreadsheet
