Pakai rumus replace saja 
Misalnya =replace(text;JumlahText;TextDiganti;PenggantiText)


________________________________
 From: Andhar Azhar <[email protected]>
To: xl <[email protected]> 
Sent: Wednesday, November 28, 2012 8:15 AM
Subject: ]] XL-mania [[ cara mengambil angka dan huruf
 

  
123456789 3 Bgaimana Klw sya mau Cabut angka 3..???  
ABCDEFG B Bgaimana Klw sya mau Cabut angka B..???    
TLG RUMUSNYA....????????????????????? 
 

________________________________
ISKANDAR AZHAR
Junior Enggeneer DistribusiKantor Pelayanan Libureng
Rayon Patangkai, Area Watampone, Wil. Sultanbatara
Email : 
[email protected]; [email protected]; [email protected]: 
[email protected]
HP :
081 241 621 170 / 085 242 391 270
________________________________



 

Kirim email ke