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' rkusya...@luxasia.co.id [belajar-excel] wrote:
Dear Exceller, Maaf file Xls-nya ketinggalan. Salam, Rakhmad*From:*belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]*Sent:* Thursday, April 30, 2015 11:29 AM *To:* belajar-excel@yahoogroups.com *Cc:* mr.nm...@gmail.com*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