Terima kasih banyak pak Hendrik..
Sent from my Samsung device
-------- Original message --------
From: "hendrik karnadi [email protected] [belajar-excel]"
<[email protected]>
Date: 06/08/2016 3:37 PM (GMT+07:00)
To: [email protected]
Subject: Re: [belajar-excel] Memisahkan teks
Jika diasumsikan teksnya selalu 10 digit maka formulanya adalah sbb
:=LEFT(SUBSTITUTE(A1,".",""),10)
Salam,HK
From: "adrian piter [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Wednesday, 8 June 2016, 13:20
Subject: [belajar-excel] Memisahkan teks
selamat siang.
mohon bantuannya bagaimana formula untuk pemisahan teks :
"01.234.567.89-000" menjadi "0123456789" atas bantuannya diucapkan terima kasih.
