Menu Click to open Menus
Home » Excel » Cara Singkat gak pakai Rumus, Memisahkan Tempat dan Tanggal lahir di Excel

Cara Singkat gak pakai Rumus, Memisahkan Tempat dan Tanggal lahir di Excel

(2948 Views) | Published by | 25 Comments

pakbudiono.com – Assalamu’alaikum wr.wb sahabat semua, mungkin anda pernah menemui suatu masalah seperti ini,  ketika di kantor atasan kita meminta laporan berupa data-data yang mana tempat dan tanggal lahir harus dipisahkan , sementara kita sudah punya format yang sebelumnya tempat dan tanggal lahirnya sudah bergabung dalam satu cell, dan yang bikin enek melihatnya apalagi untuk ngerjain permintaan si bos itu karena datanya banyak banget dan bisa dibilang ribuan.

Untuk ngilangi rasa enek dan berubah jadi enak berikut ini ada Cara Singkat gak pakai Rumus, Memisahkan Tempat dan Tanggal lahir,  yuk kita menuju TKP.

Data Awal seperti ini :

memisahkan tempat dan tgl lahir_awal

yang mau dikerjakan, gimana supaya tempat tanggal bisa terpisah dengan cepat. Langkah pertama blok kolom tempat lahir, lalu copy paste dikolom sebelah kanannya, buat copy paste sekali lagi di sebelah kanannya, kasih nama kolom sekalian yaitu tempat lahir dan tanggal lahir.

Hasilnya seperti ini :

memisahkan tempat dan tgl lahir_ke2

 

 

 

 

 

 

selanjutnya arahkan mouse pada kolom tempat lahir, lalu tekan tombol Ctrl+F , pada kotak Find What : isi dengan ,* lalu klik Replace, dan pada kotak Replace with isinya kosong, kemudian klik tombol Replace All

 

memisahkan tempat dan tgl lahir

maka akan terlihat kalau kolom Tempat lahir isinya sudah berubah  jadi tempat lahir doank, sekarang tugas selanjutnya sama seperti diatas kita kerjakan kolom tanggal lahir hanya bedanya Find What isianya dibalik jadi *,

memisahkan tempat dan tgl lahir

 

 

 

 

 

 

untuk kolom Replace with tetap dikosongkan, lalu klik Replace All dan lihat hasilnya.

Mungkin itu saja Cara Singkat gak pakai Rumus, Memisahkan Tempat dan Tanggal lahir di Excel dan semoga bermanfaat. Wassalamu’alaikumwr.wb.

25 Comments for Cara Singkat gak pakai Rumus, Memisahkan Tempat dan Tanggal lahir di Excel

  • wah terima kasih banyak pak budi, kebetulan saya mau input banyak sekali…

  • air yeezy says:

    you could have an incredible blog here! would you like to make some invite posts on my weblog?

  • I would like to point out my appreciation for your kind-heartedness in support of men and women that really need assistance with that theme. Your real commitment to passing the message all through appears to be wonderfully interesting and has constantly allowed guys and women just like me to get to their desired goals. The warm and helpful key points signifies much a person like me and even more to my fellow workers. Thank you; from each one of us.

  • Good day! I simply would like to give a huge thumbs up for the great information you have got right here on this post. I can be coming back to your blog for extra soon.

  • This really answered my problem, thanks!

  • yeezy shoes says:

    I must express my affection for your generosity giving support to men who have the need for guidance on this particular subject. Your real dedication to getting the solution around turned out to be exceptionally good and have regularly enabled individuals just like me to reach their ambitions. Your personal interesting hints and tips means so much a person like me and a whole lot more to my peers. Thanks a ton; from all of us.

  • yeezy says:

    I抦 impressed, I need to say. Actually rarely do I encounter a blog that抯 each educative and entertaining, and let me tell you, you could have hit the nail on the head. Your concept is outstanding; the problem is something that not sufficient persons are speaking intelligently about. I’m very blissful that I stumbled throughout this in my search for something relating to this.

  • I抎 have to examine with you here. Which isn’t something I normally do! I get pleasure from reading a publish that can make people think. Additionally, thanks for allowing me to remark!

  • Hi there! I just wish to give an enormous thumbs up for the great information you may have here on this post. I will probably be coming back to your blog for more soon.

  • yeezy shoes says:

    An impressive share, I just given this onto a colleague who was doing a little bit analysis on this. And he in truth purchased me breakfast as a result of I discovered it for him.. smile. So let me reword that: Thnx for the treat! But yeah Thnkx for spending the time to debate this, I really feel strongly about it and love reading extra on this topic. If doable, as you develop into expertise, would you mind updating your weblog with more details? It’s highly useful for me. Big thumb up for this blog publish!

  • air max thea says:

    After I originally commented I clicked the -Notify me when new comments are added- checkbox and now every time a comment is added I get four emails with the identical comment. Is there any way you possibly can take away me from that service? Thanks!

  • yeezy boost says:

    I wanted to compose a simple comment in order to appreciate you for those nice ways you are giving out on this website. My time consuming internet research has at the end of the day been paid with extremely good ideas to share with my friends and classmates. I ‘d admit that many of us site visitors actually are undoubtedly fortunate to dwell in a very good site with very many outstanding professionals with very helpful principles. I feel pretty happy to have encountered your webpages and look forward to plenty of more amazing minutes reading here. Thanks once again for everything.

  • yeezy boost says:

    This really answered my drawback, thank you!

  • This website online is known as a walk-by for all of the information you needed about this and didn抰 know who to ask. Glimpse right here, and also you抣l definitely uncover it.

  • Youre so cool! I dont suppose Ive read anything like this before. So nice to search out any person with some authentic thoughts on this subject. realy thanks for starting this up. this website is one thing that’s wanted on the internet, someone with a bit originality. useful job for bringing one thing new to the internet!

  • I wanted to send a brief comment to thank you for those unique steps you are giving at this site. My long internet search has at the end been honored with reliable points to go over with my friends. I ‘d assert that most of us readers actually are undeniably lucky to exist in a fine community with very many special professionals with very helpful solutions. I feel truly fortunate to have used your entire website page and look forward to really more amazing times reading here. Thanks a lot once more for everything.

  • After study a number of of the weblog posts in your web site now, and I really like your manner of blogging. I bookmarked it to my bookmark website checklist and will be checking again soon. Pls take a look at my site as nicely and let me know what you think.

  • There are some fascinating closing dates in this article but I don抰 know if I see all of them center to heart. There is some validity but I’ll take maintain opinion till I look into it further. Good article , thanks and we want extra! Added to FeedBurner as effectively

  • I found your blog site on google and check a number of of your early posts. Proceed to keep up the superb operate. I simply further up your RSS feed to my MSN Information Reader. Searching for forward to reading more from you afterward!?

  • hermes belt says:

    I found your blog website on google and examine a couple of of your early posts. Proceed to keep up the excellent operate. I just additional up your RSS feed to my MSN News Reader. Seeking ahead to studying more from you later on!?

  • It’s best to participate in a contest for top-of-the-line blogs on the web. I will recommend this web site!

  • I wanted to construct a message to express gratitude to you for the lovely ways you are giving on this site. My extensive internet lookup has at the end of the day been recognized with incredibly good information to go over with my partners. I ‘d believe that many of us site visitors actually are rather endowed to exist in a remarkable network with very many lovely people with insightful tricks. I feel pretty fortunate to have discovered the web page and look forward to some more fun minutes reading here. Thanks again for all the details.

  • After examine a few of the blog posts on your website now, and I really like your approach of blogging. I bookmarked it to my bookmark website list and can be checking back soon. Pls take a look at my website online as nicely and let me know what you think.

  • I discovered your blog website on google and verify just a few of your early posts. Continue to maintain up the superb operate. I simply further up your RSS feed to my MSN News Reader. Seeking ahead to reading more from you later on!?

  • I simply want to mention I am very new to blogging and seriously loved your web blog. Very likely I’m likely to bookmark your blog . You surely have exceptional stories. Cheers for revealing your website.

Leave a Reply

Your email address will not be published.