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
 


Kirim email ke