Salah dua cara :
=SUBSTITUTE(MID(A1,FIND("(",A1)+1,99),")","")cheers, VD "Muhammad Wildan" <[email protected]> Sent by: [email protected] 12/11/2008 09:47 PM Please respond to [email protected] To <[email protected]> cc Subject RE: ]] XL-mania [[ ambil kata-kata dalam kurung Sudah sering dibahas juga nih soal mengambil kata tertentu dari teks, salah satu cara: =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1) Asumsi: - Teks ada di cell A1 - Tidak ada tanda kurung lainnya di teks tsb selain yg ingin diambil J Thanks, MW From: [email protected] [mailto:[email protected]] On Behalf Of Yuanita Veronika Kristianti Hermawan Sent: Thursday, December 11, 2008 11:41 AM To: [email protected] Subject: ]] XL-mania [[ ambil kata-kata dalam kurung *********************** Your mail has been scanned by InterScan. PT. AJ Central Asia Raya 12/11/08 11:42:01 ***********-*********** Dear all, Aku mau tanya dong gimana ya rumus kalau kita mau ambil kata-kata dalam kurung? Contoh Yuanita Veronika ([email protected]) Susanti ([email protected]) Kata-kata yang diambil adalah [email protected] [email protected] Thx ya sebelumnya. Yuanita veronika
<<image/gif>>
