{"id":84,"date":"2023-11-17T06:46:31","date_gmt":"2023-11-17T06:46:31","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/"},"modified":"2023-12-06T11:35:25","modified_gmt":"2023-12-06T11:35:25","slug":"concatenar-celulas-com-virgula","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/","title":{"rendered":"Como concatenar c\u00e9lulas com v\u00edrgula?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-3044958735\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><div class=\"excel-before-content\" id=\"excel-1468482526\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>No Excel, existem v\u00e1rios m\u00e9todos que voc\u00ea pode usar para concatenar c\u00e9lulas usando uma v\u00edrgula entre os valores. Neste tutorial, veremos todos esses m\u00e9todos.<\/p><h2 class=\"wp-block-heading\"> Fun\u00e7\u00e3o TEXTJOIN para combinar c\u00e9lulas com um caractere comum<\/h2><p> No exemplo a seguir, voc\u00ea tem valores num\u00e9ricos no intervalo A1 a A5 e precisa combinar todos esses valores na c\u00e9lula B1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66008\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"armazenamento celular\" width=\"449\" height=\"283\"><\/figure><\/div><p> Voc\u00ea pode usar as seguintes etapas:<\/p><ol type=\"1\"><li> Primeiro, digite TEXTJOIN na c\u00e9lula B1.<\/li><li> Depois disso, para o argumento delimitador, adicione uma v\u00edrgula (\u201c,\u201c). Isso tamb\u00e9m inclui um espa\u00e7o ap\u00f3s a v\u00edrgula.<\/li><li> Em seguida, insira TRUE para ignore_empty.<\/li><li> Agora selecione o intervalo A1:A5 de onde voc\u00ea precisa combinar os valores.<\/li><li> No final, insira o par\u00eantese de fechamento e pressione Enter. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66009\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formule-textjoin.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula textjoin\" width=\"626\" height=\"280\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXTJOIN(\", \",TRUE,A1:A5)<\/code><\/pre><h2 class=\"wp-block-heading\"> Use a fun\u00e7\u00e3o CONCAT para concatenar valores com v\u00edrgula<\/h2><p> Voc\u00ea tamb\u00e9m pode usar a fun\u00e7\u00e3o CONCAT para isso. Mas voc\u00ea precisa adicionar uma coluna auxiliar com v\u00edrgulas ao lado dos valores reais. No exemplo a seguir, adicionamos v\u00edrgulas na coluna B (B1:B5). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66010\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-concat-pour-combiner-les-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"c\u00e9lulas concat-para-combinar\" width=\"479\" height=\"305\"><\/figure><\/div><p> Agora a f\u00f3rmula \u00e9 bem simples. Basta inserir a fun\u00e7\u00e3o CONCAT na c\u00e9lula C1 e consultar todo o intervalo (A1:B5). Ao pressionar Enter, voc\u00ea obter\u00e1 todos os valores da c\u00e9lula C1, seguidos de v\u00edrgula. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66011\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-formules-concat1.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula concat\" width=\"651\" height=\"289\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CONCAT(A1:B5)<\/code><\/pre><h2 class=\"wp-block-heading\"> Usando o m\u00e9todo de concatena\u00e7\u00e3o simples<\/h2><p> E voc\u00ea tamb\u00e9m pode usar o m\u00e9todo de concatena\u00e7\u00e3o simples, onde voc\u00ea pode se referir a cada c\u00e9lula e com cada refer\u00eancia de c\u00e9lula voc\u00ea pode adicionar uma v\u00edrgula. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66012\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-methode-de-concatenation-simple.png\" sizes=\"auto, \" srcset=\"\" alt=\"m\u00e9todo de concatena\u00e7\u00e3o simples\" width=\"682\" height=\"312\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1&amp;\", \"&amp;A2&amp;\", \"&amp;A3&amp;\", \"&amp;A4&amp;\", \"&amp;A5<\/code><\/pre><p> De todos os m\u00e9todos que usamos, cada m\u00e9todo tem sua vantagem. Mas gosto de usar TEXTJOIN porque me d\u00e1 mais flexibilidade para combinar valores em uma \u00fanica c\u00e9lula sem adicionar uma nova coluna auxiliar. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtenha o arquivo Excel<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/9-valeurs-de-concatenation-avec-des-virgules.xlsx\" rel=\"nofollow\">Download<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/pt\/formulas\/\">Lista de f\u00f3rmulas do Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/nova-linha-na-celula\/\">Adicione uma nova linha a uma c\u00e9lula no Excel (quebra de linha)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/zeros-a-esquerda\/\">Adicione zeros \u00e0 esquerda no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/concatenar-um-intervalo-de-celulas\/\">Concatenar (combinar) um intervalo de c\u00e9lulas no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/concatenar-uma-quebra-de-linha\/\">Concatenar com quebra de linha no Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-84","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como concatenar (combinar) c\u00e9lulas com v\u00edrgula?<\/title>\n<meta name=\"description\" content=\"Neste tutorial, voc\u00ea aprender\u00e1 diferentes maneiras de concatenar (combinar) c\u00e9lulas com v\u00edrgula em f\u00f3rmulas do Excel\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como concatenar (combinar) c\u00e9lulas com v\u00edrgula?\" \/>\n<meta property=\"og:description\" content=\"Neste tutorial, voc\u00ea aprender\u00e1 diferentes maneiras de concatenar (combinar) c\u00e9lulas com v\u00edrgula em f\u00f3rmulas do Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:35:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/\",\"name\":\"Como concatenar (combinar) c\u00e9lulas com v\u00edrgula?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png\",\"datePublished\":\"2023-11-17T06:46:31+00:00\",\"dateModified\":\"2023-12-06T11:35:25+00:00\",\"description\":\"Neste tutorial, voc\u00ea aprender\u00e1 diferentes maneiras de concatenar (combinar) c\u00e9lulas com v\u00edrgula em f\u00f3rmulas do Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como concatenar c\u00e9lulas com v\u00edrgula?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como concatenar (combinar) c\u00e9lulas com v\u00edrgula?","description":"Neste tutorial, voc\u00ea aprender\u00e1 diferentes maneiras de concatenar (combinar) c\u00e9lulas com v\u00edrgula em f\u00f3rmulas do Excel","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:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/","og_locale":"pt_PT","og_type":"article","og_title":"Como concatenar (combinar) c\u00e9lulas com v\u00edrgula?","og_description":"Neste tutorial, voc\u00ea aprender\u00e1 diferentes maneiras de concatenar (combinar) c\u00e9lulas com v\u00edrgula em f\u00f3rmulas do Excel","og_url":"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:35:25+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/","url":"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/","name":"Como concatenar (combinar) c\u00e9lulas com v\u00edrgula?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png","datePublished":"2023-11-17T06:46:31+00:00","dateModified":"2023-12-06T11:35:25+00:00","description":"Neste tutorial, voc\u00ea aprender\u00e1 diferentes maneiras de concatenar (combinar) c\u00e9lulas com v\u00edrgula em f\u00f3rmulas do Excel","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/concatenar-celulas-com-virgula\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como concatenar c\u00e9lulas com v\u00edrgula?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/84","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=84"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/84\/revisions"}],"predecessor-version":[{"id":904,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/84\/revisions\/904"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}