Kalau strukutur datanya sama anda tinggal pasang formula : =Left(Sel,berapa karakter)&Mid(sell,mulai karakter ke berapa, berapa karakter), dstnya
Salam, Hendrik Karnadi ________________________________ From: Niki Dwinarni <[email protected]> To: [email protected] Sent: Friday, April 29, 2011 17:17:39 Subject: [belajar-excel] format angka Tolong bantuanya gimana rumusnya mengubah 240100636168 jadi 240-10063-6168, 081372258110 jadi 0813 7225 8110. trimakasih
