Gunakan fasilitas text to column dengan delimeters [space]

Pilih/Block kolom A, dari menu [Data], pilih [Text to Columns..]

Pakai pilihan delimeted denga delimeters [space]

 

 

  _____  

From: Asep Permana [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 09, 2008 11:22 AM
To: [email protected]
Subject: ]] XL-mania [[ bongkar data di antara space

 


Selamat siang..

Para XL-Mania yang makin master-mater, tolong kasih solusi buat bongkar data
diantara dua space, seperti data terlampir

 

terimaksih sebelumnya

 

 

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 3506 (20081009) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


__________ Information from ESET NOD32 Antivirus, version of virus signature
database 3506 (20081009) __________


The message was checked by ESET NOD32 Antivirus.


http://www.eset.com

Kirim email ke