Pendidikan Tiada Batas

Tempat dan tanggal lahir di Excel

Pada postingan sebelumnya telah di sampaikan tentang Menggabungkan data tanggal, dengan tampilan seperti pada gambar di bawah ini

Namun masih ada teman yang menanyakan, bagaimana kalau pada tampilan nama bulan tertulis huruf dari nama bulan tersebut, bukan angka seperti gambar di atas? Untuk menampilkan nama buan dalam bahasa Indonesia, kita perlu membuat tabel/range nama-nama bulan, seperti pada gambar di bawah ini.

tempat2Tabel tersebut nantinya akan menampilkan nama-nama bulan dengan fungsi VLOOKUP. Agar lebih mudah tabel/range tersebut kita beri nama. langkahnya :

-blok tabel

– klik menu Formulas

– pilih Nama Manager

– pilih New

– ketik nama tabel

OK. dalam hal ini tabel tersebut saya beri nama “bulan”,  seperti tampak pada “NameBox” pada gambar di samping.

cara memberi nama tabel yang lebih praktis adalah sebagai berikut : blok tabel – klik pada kota “NameBox”- ketik nama tabel – lalu tekan enter. cara kedua ini menurut saya lebih praktis, tanpa harus klik sana klik sini.

Seteleh tabel kita beri nama, maka data tabel tersebut dapat kita panggil dengan fungsi vlookup seperti gambar di bawah ini.

tempat 1

ada yang lebih praktis? mohon masukannya.

Cara lainnya adalah mengubah type data tanggal menjadi bertipe teks, lalu menggabungkannya. cara ini lebih praktis, namun format tanggal menyesuaikan seting regional. contoh

jika dibuat rumus =A5&”, “&TEXT(B5,”dd-mm-yyyy”) maka hasilnya Jakarta, 03-05-2014

Share

Comments

comments

7 Comments

  1. October 21, 2014    

    terima kasih pak Budi, ini tutorial lagi sedang saya cari – cari 🙂 , akhirnya ketemu juga 🙂 semoga saya bisa seperti pak Budi bisa menyebarkan ilmunya kepada banyak orang 🙂

  2. June 28, 2014    

    Did they arrive for the appointment on time as agreed. It is indeed the very basic rule that you have to keep in mind.
    Or you can even use a continual pump for that water to
    recycle on its own.

  3. January 15, 2014    

    lama gak utak atik excel. setelah baca postingan bapak, jadi pusing. hehehe.. thanks, pak. sejak dulu dalam penggunaan excel, saya macetnya di bagian ini. rumit rasanya.

  4. January 12, 2014    

    The Amazon Kindle Fire though has a very limited Amazon Android App store with no easy way to
    access Google Play. Colors become extra luminous when you play games, observe
    images or observe tapes. Sadly, there isn’t a 3G version, but I’m given
    to understand you can buy separate adapters for that.

  5. January 12, 2014    

    I believe everything published was actually very reasonable.
    But, consider this, what if you were to write a killer headline?
    I am not suggesting your content isn’t solid., however what if you added a
    title that grabbed folk’s attention? I mean Tempat dan tanggal lahir di Excel is kinda plain.
    You could glance at Yahoo’s front page and note how they create
    post titles to get people interested. You might try adding a video
    or a related picture or two to get readers excited about
    what you’ve written. In my opinion, it might bring your posts a little bit more interesting.

  6. January 12, 2014    

    I comment each time I appreciate a article on a website or I have something to add to the conversation.
    Usually it’s triggered by the sincerness communicated in the post I browsed.
    And after this post Tempat dan tanggal lahir di Excel . I was excited enough to drop a thought 🙂 I
    actually do have 2 questions for you if it’s okay.
    Could it be only me or do a few of these responses come
    across like they are written by brain dead people? 😛 And, if
    you are posting on other places, I’d like to follow you.
    Could you make a list all of all your communal pages like your Facebook page, twitter feed, or linkedin profile?

  7. January 11, 2014    

    I seldom comment, however i did a few searching and wound up here Tempat dan tanggal lahir di Excel .
    And I actually do have 2 questions for you if you tend
    not to mind. Is it only me or does it look like a few of
    the responses look like left by brain dead visitors?

    😛 And, if you are posting at additional sites, I would like to keep up with everything fresh you have to post.
    Could you make a list of all of all your social pages like
    your twitter feed, Facebook page or linkedin profile?

No Pings Yet

  1. menggabungkan tanggal di excel | www.budies.info on March 25, 2015 at 22:04

Leave a Reply

Your email address will not be published. Required fields are marked *

Download this post as PDF

berrybenka

cari produk di Lazada

Google+ follower

Belanja di LAZADA

Lazada Indonesia

Get paid to share your links!
SEO Powered by Platinum SEO from Techblissonline