[belajar-excel] format angka

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] format angka

Niki Dwinarni
Tolong bantuanya gimana rumusnya mengubah 240100636168 jadi 240-10063-6168, 081372258110 jadi 0813 7225 8110. trimakasih


Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] format angka

Kid
Administrator
Asumsi, data source bertype text di kolom A mulai baris 2

di cell b2 ketik
=text(--a2, IF( Len(a2)<12 , "0000 0000 0000" , "000-00000-0000" ) )

Mungkin begitu.

Kid.

2011/4/29 Niki Dwinarni <[hidden email]>

>
>
> Tolong bantuanya gimana rumusnya mengubah 240100636168 jadi 240-10063-6168,
> 081372258110 jadi 0813 7225 8110. trimakasih
>
>
>  
>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] format angka

hendrik karnadi
In reply to this post by Niki Dwinarni
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 <[hidden email]>
To: [hidden email]
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


 
 
Reply | Threaded
Open this post in threaded view
|

Fw: [belajar-excel] format angka

hendrik karnadi
In reply to this post by Niki Dwinarni
Maaf,jika dingin ditambahkan karakter "-", formulanya menjadi :
=Left(Sel,berapa karakter)&"-"&Mid(sell,mulai karakter ke berapa, berapa
karakter), dstnya

dan
jika dingin ditambahkan karakter " " (blank), formulanya menjadi :
=Left(Sel,berapa karakter)&" "&Mid(sell,mulai karakter ke berapa, berapa
karakter), dstnya





----- Forwarded Message ----
From: hendrik karnadi <[hidden email]>
To: [hidden email]
Sent: Saturday, April 30, 2011 15:16:49
Subject: Re: [belajar-excel] format angka


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 <[hidden email]>
To: [hidden email]
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