{"id":5210,"date":"2014-06-30T14:35:10","date_gmt":"2014-06-30T07:35:10","guid":{"rendered":"http:\/\/sinaulinux.martianuswb.com\/?p=2543"},"modified":"2014-06-30T14:35:10","modified_gmt":"2014-06-30T07:35:10","slug":"libreoffice-calc-menggabungkan-isi-sel","status":"publish","type":"post","link":"http:\/\/martianuswb.com\/?p=5210","title":{"rendered":"LibreOffice Calc: menggabungkan isi sel"},"content":{"rendered":"<p>Kasusnya ada dua sel yang ingin kita gabungkan isinya menjadi satu sel saja. Di sini digunakan aplikasi LibreOffice Calc. Ambil contoh, kita punya kolom Tempat Lahir dan kolom Tanggal Lahir, yang ingin kita gabungkan menjadi satu di kolom Tempat\/Tanggal Lahir.<\/p>\n<div id=\"attachment_2527\" style=\"width: 310px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Selection_001.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2527\" class=\"wp-image-2527 size-medium\" src=\"http:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Selection_001-300x77.png\" alt=\"Menggabungkan isi sel A1 dan B1 di sel C1. \" width=\"300\" height=\"77\" \/><\/a><p id=\"caption-attachment-2527\" class=\"wp-caption-text\">Sel A1 dan B1 akan digabungkan ke sel C1. Silakan klik untuk memperbesar gambar.<\/p><\/div>\n<p>Caranya sebenarnya cukup mudah, tinggal menggunakan fungsi DAN (=AND) atau &amp;. Jadi di contoh di bawah, sel A2 berisi teks Surakarta, dan sel B2 berisi teks 27 Juni 2014. Jika ingin kita gabungkan di sel C2, tinggal masukkan perintah =A2&amp;B2. Tentu saja hasilnya akan menjadi \u201cSurakarta27 Juni 2014\u201d.<\/p>\n<div id=\"attachment_2539\" style=\"width: 310px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Selection_002.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2539\" class=\"wp-image-2539 size-medium\" src=\"http:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Selection_002-300x92.png\" alt=\"Sel C2 diisi dengan rumus =A2&amp;B2. \" width=\"300\" height=\"92\" \/><\/a><p id=\"caption-attachment-2539\" class=\"wp-caption-text\">C2=A2&amp;B2. Silakan klik untuk memperbesar gambar.<\/p><\/div>\n<p>Untuk menyisipkan teks, maka digunakan tanda kutip ganda (\u201c \u201c). Bisa dilihat di gambar di bawah.<\/p>\n<div id=\"attachment_2544\" style=\"width: 310px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Selection_003.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2544\" class=\"wp-image-2544 size-medium\" src=\"http:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Selection_003-300x92.png\" alt=\"Spasi disisipkan di antara isi dua sel. \" width=\"300\" height=\"92\" \/><\/a><p id=\"caption-attachment-2544\" class=\"wp-caption-text\">C3=A3&amp;&#8221; &#8220;&amp;B3. Silakan klik untuk memperbesar gambar.<\/p><\/div>\n<div id=\"attachment_2545\" style=\"width: 310px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Selection_004.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2545\" class=\"wp-image-2545 size-medium\" src=\"http:\/\/martianuswb.com\/wp-content\/uploads\/2014\/06\/Selection_004-300x92.png\" alt=\"Menyisipkan teks di antara dua isi sel.\" width=\"300\" height=\"92\" \/><\/a><p id=\"caption-attachment-2545\" class=\"wp-caption-text\">C4=A4&amp;&#8221;, &#8220;&amp;B4. Silakan klik untuk memperbesar gambar.<\/p><\/div>\n<p>Cukup mudah, tidak perlu mengetik ulang seluruh data.<\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>Kasusnya ada dua sel yang ingin kita gabungkan isinya menjadi satu sel saja. Di sini digunakan aplikasi LibreOffice Calc. Ambil contoh, kita punya kolom Tempat Lahir dan kolom Tanggal Lahir,&#8230; <a href=\"http:\/\/martianuswb.com\/?p=5210\">Read more &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1403],"tags":[1414,1438,1486,1525,1678,1726],"class_list":["post-5210","post","type-post","status-publish","format-standard","hentry","category-libreoffice","tag-1414","tag-and","tag-calc","tag-dan","tag-libreoffice","tag-menggabungkan-isi-sel"],"_links":{"self":[{"href":"http:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/posts\/5210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/martianuswb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5210"}],"version-history":[{"count":0,"href":"http:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/posts\/5210\/revisions"}],"wp:attachment":[{"href":"http:\/\/martianuswb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/martianuswb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5210"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/martianuswb.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}