This is default featured post 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 2 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 3 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 5 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

24 Jul 2013

Memisahkan Tempat Lahir Dan Tanggal Lahir



Memisahkan Tempat Lahir Dan Tanggal Lahir

Ada cara singkat untuk memisahkan tempat lahir dan tanggal lahir contoh "Subang, 10 Mei 1970";
Cara 1 (Dengan formula excel) :
Misal data ada di cell A1, di cell B1 masukan formula "=LEFT(A1;FIND(",";A1)-1)" hasilnya "Subang" dan di cell C1 masukan formula "=VALUE(RIGHT(A1;LEN(A1)-FIND(",";A1)-1))" hasilnya "10 Mei 1970" (tergantung dengan format cell yang ditentukan anda)
Cara 2 (Dengan find and replace excel) :
Misal data ada di cell A1, di cell A1 klik tombol ctrl dan F berbarengan di tab replace masukan ",* " hasilnya "Subang" jika yang dimasukan "*, " hasilnya "10 Mei 1970" (tergantung dengan format cell yang ditentukan anda);
Selamat Mencoba !!!

23 Jul 2013

DOA SEHARI – HARI


1.DOA MASUK MASJID
اللَّهُمَّ اغْفِرْلِي ذُنُوْبِي وَافْتَحْ لِي أَبْوَابَ رَحْمَتِكَ     
Allahummaghfirlii dzunuubii waftahli abwabaa rohmatika
2.DOA KELUAR MASJID
اللَّهُمَّ اغْفِرْلِي ذُنُوْبِي وَافْتَحْ لِي أَبْوَابَ مِنْ فَضْلِكَ
Allahummaghfirlii dzunuubii waftahli abwabaa min fadlika

Kolom