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 !!!

2 komentar:

IMFORMASI BAGI PEMAIN TOGEL?
Bagi teman2 yg berminat menang angka togel ghoib 2d 3d dan 4d di jamin tembus 100% hasil ritual,silahakan hub mbah korjo di nomeer:0853-9766-5959.sya sudah buktikan angka dari mbah korjo dan sya menang 3d.terimahkasih.

Yet again, when kids are included, the sentiments are increased along with uncooked, thus having a person who is objective might help make sure that your and your childrens interests are now being supported. It's also best to have somebody to assist you comprehend the procedure and how it really works along with keeps an individual based along the route. Efficiency is a second need to work with a divorce attorney.
Divorce Lawyer Virginia
The thought of ending one a part of their particular our life is discouraging, causing considerably hardship along with misunderstandings. The last thing that these individuals need to handle could be the search for a divorce attorney. Those who are dealing with any divorce will frequently find that they are managing a tremendously difficult and mental predicament. Thinking about finishing one particular a part of their life's discouraging, creating much stress along with confusion.

Poskan Komentar

Kolom