kalau datanya seperti ini ?? PT. MAJU OGAH, GEDUNG MEGAH, LANTAI 10 KAMAR 35, GANG BATU NO.5, SINGAPARNA bgmana dong... ??
-------------------------------------------------------------------------------- ----- Original Message ----- From: zainul ulum To: [email protected] Sent: Wednesday, February 03, 2010 4:12 PM Subject: RE: [belajar-excel] Memisahkan data 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)

