{"id":2168,"date":"2021-10-09T09:26:00","date_gmt":"2021-10-09T07:26:00","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=2168"},"modified":"2022-04-18T12:52:52","modified_gmt":"2022-04-18T10:52:52","slug":"spajanje-sadrzaja-iz-celija-tabele","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/","title":{"rendered":"Spajanje sadr\u017eaja iz \u0107elija tabele"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Sadr\u017eaj<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/#Spajanje_sadrzaja_iz_celija_tabele\" >Spajanje sadr\u017eaja iz \u0107elija tabele<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/#Stara_formula_CONCATENATE\" >Stara formula CONCATENATE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/#Nova_formula_CONCAT\" >Nova formula CONCAT<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/#Old_formula_CONCATENATE\" >Old formula CONCATENATE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/#New_CONCAT_formula\" >New CONCAT formula<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\nSpajanje sadr\u017eaja iz \u0107elija tabele javlja se uvek kada imamo vi\u0161e kolona. Ne znam koliko sam puta imao potrebe da spajam sadr\u017eaj iz vi\u0161e \u0107elija tabele, ali ovog trenutka se ne mogu setiti boljeg razloga od spajanja imena i prezimena u jednu kolonu.<\/p>\n<p>Najbr\u017ei na\u010din spajanja sadr\u017eaja iz dve i vi\u0161e \u0107elija mo\u017eete obaviti uz pomo\u017e operatora ampersend [<a href=\"https:\/\/en.wikipedia.org\/wiki\/Ampersand\" target=\"_blank\" rel=\"noopener\"><strong>&amp;<\/strong><\/a>]. I sintaksa je jednostavna, samo je primenite nad \u0107elijom gde vam je potreban rezultat.<\/p>\n<p style=\"text-align: left;\"><strong>=A1&amp;B1&amp;C1&amp;D1<\/strong><\/p>\n<p>Isti taj posao mo\u017eete obaviti i upotrebom formule <strong>CONCATENATE<\/strong>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Spajanje_sadrzaja_iz_celija_tabele\"><\/span>Spajanje sadr\u017eaja iz \u0107elija tabele<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Od <a href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/\">verzije Excel 2019<\/a> imamo i zna\u010dajno unapre\u0111enje upotrebom formule <strong>CONCAT<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2169\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/10\/concat1.png\" alt=\"\" width=\"574\" height=\"177\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/10\/concat1.png 574w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/10\/concat1-300x93.png 300w\" sizes=\"auto, (max-width: 574px) 100vw, 574px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Stara_formula_CONCATENATE\"><\/span>Stara formula CONCATENATE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: left;\"><strong>=CONCATENATE(A1;B1;C1;D1)<\/strong><\/p>\n<p>Svaka \u0107elija se mora posebno navesti kao varijabla.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Nova_formula_CONCAT\"><\/span>Nova formula CONCAT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: left;\"><strong>=CONCAT(A1:D1)<\/strong><\/p>\n<p>Neka ograni\u010denja su u novoj formuli prevazi\u0111ena, tako sada se mo\u017ee obuhvatiti \u010ditava oblast vrednosti bez posebno navo\u0111enja.<\/p>\n<p>Ovu \u0107emo pri\u010du svakako pro\u0161iriti, ako za to ima potrebe.\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;2168&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Ocenite post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Spajanje sadr\u017eaja iz \u0107elija tabele&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            <span class=\"kksr-muted\">Ocenite post<\/span>\n    <\/div>\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>Spajanje sadr\u017eaja iz \u0107elija tabele javlja se uvek kada imamo vi\u0161e kolona. Ne znam koliko sam puta imao potrebe da<\/p>\n","protected":false},"author":1,"featured_media":2169,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-2168","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ekscel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Spajanje sadr\u017eaja iz \u0107elija tabele<\/title>\n<meta name=\"description\" content=\"Spajanje sadr\u017eaja iz \u0107elija tabele ne mora biti zamorno. Postoji vi\u0161e na\u010dina da spojimo re\u0161i iz vi\u0161e kolona.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Spajanje sadr\u017eaja iz \u0107elija tabele\" \/>\n<meta property=\"og:description\" content=\"Spajanje sadr\u017eaja iz \u0107elija tabele ne mora biti zamorno. Postoji vi\u0161e na\u010dina da spojimo re\u0161i iz vi\u0161e kolona.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-09T07:26:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-18T10:52:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/10\/concat1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"574\" \/>\n\t<meta property=\"og:image:height\" content=\"177\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/spajanje-sadrzaja-iz-celija-tabele\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/spajanje-sadrzaja-iz-celija-tabele\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"Spajanje sadr\u017eaja iz \u0107elija tabele\",\"datePublished\":\"2021-10-09T07:26:00+00:00\",\"dateModified\":\"2022-04-18T10:52:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/spajanje-sadrzaja-iz-celija-tabele\\\/\"},\"wordCount\":353,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/spajanje-sadrzaja-iz-celija-tabele\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/concat1.png\",\"articleSection\":[\"Poslovni Excel\"],\"inLanguage\":\"sr-SR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/spajanje-sadrzaja-iz-celija-tabele\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/spajanje-sadrzaja-iz-celija-tabele\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/spajanje-sadrzaja-iz-celija-tabele\\\/\",\"name\":\"Spajanje sadr\u017eaja iz \u0107elija tabele\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/spajanje-sadrzaja-iz-celija-tabele\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/spajanje-sadrzaja-iz-celija-tabele\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/concat1.png\",\"datePublished\":\"2021-10-09T07:26:00+00:00\",\"dateModified\":\"2022-04-18T10:52:52+00:00\",\"description\":\"Spajanje sadr\u017eaja iz \u0107elija tabele ne mora biti zamorno. Postoji vi\u0161e na\u010dina da spojimo re\u0161i iz vi\u0161e kolona.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/spajanje-sadrzaja-iz-celija-tabele\\\/#breadcrumb\"},\"inLanguage\":\"sr-SR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/spajanje-sadrzaja-iz-celija-tabele\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/spajanje-sadrzaja-iz-celija-tabele\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/concat1.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/concat1.png\",\"width\":574,\"height\":177},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/spajanje-sadrzaja-iz-celija-tabele\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Spajanje sadr\u017eaja iz \u0107elija tabele\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sr-SR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Spajanje sadr\u017eaja iz \u0107elija tabele","description":"Spajanje sadr\u017eaja iz \u0107elija tabele ne mora biti zamorno. Postoji vi\u0161e na\u010dina da spojimo re\u0161i iz vi\u0161e kolona.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/","og_locale":"en_US","og_type":"article","og_title":"Spajanje sadr\u017eaja iz \u0107elija tabele","og_description":"Spajanje sadr\u017eaja iz \u0107elija tabele ne mora biti zamorno. Postoji vi\u0161e na\u010dina da spojimo re\u0161i iz vi\u0161e kolona.","og_url":"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2021-10-09T07:26:00+00:00","article_modified_time":"2022-04-18T10:52:52+00:00","og_image":[{"width":574,"height":177,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/10\/concat1.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"Spajanje sadr\u017eaja iz \u0107elija tabele","datePublished":"2021-10-09T07:26:00+00:00","dateModified":"2022-04-18T10:52:52+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/"},"wordCount":353,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/10\/concat1.png","articleSection":["Poslovni Excel"],"inLanguage":"sr-SR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/","url":"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/","name":"Spajanje sadr\u017eaja iz \u0107elija tabele","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/10\/concat1.png","datePublished":"2021-10-09T07:26:00+00:00","dateModified":"2022-04-18T10:52:52+00:00","description":"Spajanje sadr\u017eaja iz \u0107elija tabele ne mora biti zamorno. Postoji vi\u0161e na\u010dina da spojimo re\u0161i iz vi\u0161e kolona.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/#breadcrumb"},"inLanguage":"sr-SR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/"]}]},{"@type":"ImageObject","inLanguage":"sr-SR","@id":"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/10\/concat1.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/10\/concat1.png","width":574,"height":177},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/spajanje-sadrzaja-iz-celija-tabele\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Spajanje sadr\u017eaja iz \u0107elija tabele"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sr-SR"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"sr-SR","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/2168","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=2168"}],"version-history":[{"count":5,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/2168\/revisions"}],"predecessor-version":[{"id":2641,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/2168\/revisions\/2641"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/2169"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=2168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=2168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=2168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}