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)

Kirim email ke