Pak haris; coba begini, misal data ada di cell A1
=IF(--LEFT(A1,1)=0,"00"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," ",""),RIGHT(SUBSTITUTE(A1," ",""),1),""),0,""),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," ",""),RIGHT(SUBSTITUTE(A1," ",""),1),""),0,"")) Wassalam ~ Bagus ~ ----- Original Message ----- From: ris ha [email protected] [belajar-excel] To: [email protected] Sent: Monday, September 22, 2014 8:33 AM Subject: [belajar-excel] Menghilangkan karakter spasi dan 0 (Dinamis) Assalamu'alaikum. Sukses selalu bagi para master semua. Bagaimana caranya menghilangkan karakter spasi dan angka 0 (Nol) secara dinamis. Contoh Data Hasil 516 0705 0809 C 5167589 001 2301 0240 C 00123124 Terima Kasih Wassalam Haris
