Rumus di C5=TRIM(LEFT(B5,SEARCH("j?.",B5)-1))
Rumus di D5=MID(B5,SEARCH("j?.",B5),99)________________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Aghoest Iwan Sent: Wednesday, February 03, 2010 3:49 PM To: [email protected] Subject: [belajar-excel] Memisahkan data Dear all Masters, Terlampir kasus data untuk diolah, hanya utk memisahkan Nama & alamat di kolom berbeda, dari yang sebelumnya jadi satu kolom. Mohon petunjuk para master.. Great success for all masters.. n Thanks before.. (iwan) __________ Information from ESET NOD32 Antivirus, version of virus signature database 4830 (20100203) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com

