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®
-----Original Message-----
From: "Alfan Atas Pujianto [email protected] [belajar-excel]"
<[email protected]>
Sender: [email protected]
Date: Tue, 13 May 2014 16:35:51
To: <[email protected]>
Reply-To: [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.xlsx
Description: Binary data
