Kalau di komputer saya tampilannya seperti ini :
tapi ternyata setelah di edit (F2) tampilannya seperti ini : saya coba pakai formula ini : =SUBSTITUTE(E2," ","") semoga berhasil. Salam, uharyantoOn 30/04/2015 12:17 PM, 'Rakhmad' [email protected] [belajar-excel] 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/>
Master-Template_BPOM notifikasi.xlsx
Description: MS-Excel 2007 spreadsheet
