Coba tulis function,
=SUBSTITUTE(B4,"-","")

pada sel C4, kemudian copas ke bawah.

Salam,
Hendrik Karnadi



________________________________
 From: Lazuardi Biru <[email protected]>
To: "[email protected]" <[email protected]> 
Sent: Wednesday, 27 February 2013, 16:39
Subject: ]] XL-mania [[ mengurangi karakter atau angka pada suatu cel
 

  


bagaimana membuat  formula diatas, para master exel tolong dibantu 
 
 
 

Kirim email ke