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..? > > > > [image: 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/> > > This email has been checked for viruses by Avast antivirus software. > www.avast.com > > >
