Dear Exceller,
Terima kasih atas pencerahannya. Wassalam, Rakhmad From: [email protected] [mailto:[email protected]] Sent: Thursday, April 30, 2015 12:55 PM To: BeExcel Subject: Re: FW: [belajar-excel] Hilangkan Special Character dengan rumus Hai Rakhmad, Karakter tersebut adalah karakter control berupa linefeed (LF) yang memiliki kode ASCII 10. Coba : > blok area datanya -> Replace (CTRL H) -> find what : tekan CTRL J -> replace > with : isi dengan spasi (klik spasi di keyboard) -> replace all Jika dengan formula (diletakkan di kolom lain) =Substitute( cell_data , char(10) , " " ) Terkadang karakter control berupa LF hadir setelah CR. Jadi jika ada CR LF, maka find what tekan CTRL M lalu tekan CTRL J CTRL J setara control untuk LF alias ASCII 10 CTRL M setara control untuk CR alias ASCII 13 karakter control dimulai dari ASCII 0 sampai ASCII 31. Daftar tombol control untuk karakter control tersebut bisa dilihat disini <http://academic.evergreen.edu/projects/biophysics/technotes/program/ascii_ctrl.htm> . Wassalam, Kid On Thu, Apr 30, 2015 at 3:17 PM, 'Rakhmad' [email protected] [belajar-excel] <[email protected]> wrote: Dear Exceller, Maaf file Xls-nya ketinggalan. Salam, Rakhmad From: [email protected] [mailto:[email protected]] Sent: Thursday, April 30, 2015 11:29 AM To: [email protected] Cc: [email protected] Subject: [belajar-excel] Hilangkan Special Character dengan rumus [1 Attachment] Dear Exceller, Mohon pencerahan bagaimana menghilangkan Special character [?] dengan rumus..? Character 2015-04-30 11.18.19.png Salam, Rakhmad _____ <http://www.avast.com/> This email has been checked for viruses by Avast antivirus software. www.avast.com <http://www.avast.com/> _____ <http://www.avast.com/> This email has been checked for viruses by Avast antivirus software. www.avast.com <http://www.avast.com/> --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com
