{"id":2203,"date":"2024-05-11T07:04:28","date_gmt":"2024-05-11T07:04:28","guid":{"rendered":"http:\/\/pt.repairmsexcel.com\/blog\/?p=2203"},"modified":"2024-05-11T13:00:26","modified_gmt":"2024-05-11T13:00:26","slug":"excel-textjoin-funcao-nao-trabalhando","status":"publish","type":"post","link":"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando","title":{"rendered":"Excel TEXTJOIN n\u00e3o funciona? Descubra a solu\u00e7\u00e3o aqui!"},"content":{"rendered":"<div class=\"cb46ff181ce6eef70c33ac8d8c9c88c4\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">Como todos sabemos, o Microsoft Excel vem com v\u00e1rios recursos, f\u00f3rmulas e fun\u00e7\u00f5es. A fun\u00e7\u00e3o TEXTJOIN \u00e9 uma delas. \u00c9 uma excelente fun\u00e7\u00e3o para combinar texto de v\u00e1rias c\u00e9lulas em uma c\u00e9lula. Mas \u00e0s vezes os usu\u00e1rios encontram problemas quando o <strong>Excel TEXTJOIN n\u00e3o funciona<\/strong>. Bem, neste blog, exploraremos os motivos comuns pelos quais o TEXTJOIN n\u00e3o funciona e forneceremos solu\u00e7\u00f5es vi\u00e1veis para corrigi-lo de maneira descomplicada.<!--more--><\/p>\n<p style=\"text-align: justify;\">Mas antes de nos aprofundarmos nas corre\u00e7\u00f5es, vamos explorar mais informa\u00e7\u00f5es sobre esta fun\u00e7\u00e3o do Excel.<\/p>\n<h2 style=\"text-align: left;\"><strong>Qual \u00e9 a fun\u00e7\u00e3o TEXTJOIN no Excel e por que ela \u00e9 usada?<\/strong><\/h2>\n<p style=\"text-align: justify;\">O Microsoft Excel 2016 surgiu com 6 novas fun\u00e7\u00f5es, das quais uma fun\u00e7\u00e3o \u00e9 \u2018<strong>TEXTJOIN\u2019<\/strong>. Antes da chegada da fun\u00e7\u00e3o TEXTJOIN para unir quaisquer strings de texto de intervalos de c\u00e9lulas no Excel, precisamos escolher cada c\u00e9lula individual presente nesse intervalo.<\/p>\n<p style=\"text-align: justify;\">Alternativamente, voc\u00ea pode criar uma fun\u00e7\u00e3o personalizada, para a qual voc\u00ea precisa ser altamente qualificado. Felizmente, com o uso desta fun\u00e7\u00e3o TEXTJOIN, toda esta tarefa fica muito simplificada agora. Uma grande vantagem de usar a fun\u00e7\u00e3o \u2018<strong>TEXTJOIN\u2019<\/strong> \u00e9 que ela permite escolher intervalos de c\u00e9lulas em vez de refer\u00eancias de c\u00e9lulas individuais.<\/p>\n<p style=\"text-align: justify;\">A principal fun\u00e7\u00e3o da fun\u00e7\u00e3o TEXTJOIN do Excel \u00e9 mesclar sequ\u00eancias de texto de v\u00e1rios intervalos ou c\u00e9lulas. Depois disso, separe todos os valores combinados usando qualquer delimitador especificado. Esta fun\u00e7\u00e3o pode incluir ou ignorar c\u00e9lulas vazias na sa\u00edda. Principalmente esta fun\u00e7\u00e3o Excel TEXTJOIN est\u00e1 dispon\u00edvel para Excel 2019 e Office 365.<\/p>\n<p style=\"text-align: justify;\">A seguir est\u00e1 a sintaxe da fun\u00e7\u00e3o TEXTJOIN:<\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><strong>TEXTJOIN(delimiter, ignore_empty, text1, [text2], \u2026)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\">Vamos entender esta fun\u00e7\u00e3o do Excel mais claramente com um exemplo:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4722 aligncenter\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/1.png\" alt=\"Excel TEXTJOIN n\u00e3o funciona\" width=\"1018\" height=\"283\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/1.png 1018w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/1-768x214.png 768w\" sizes=\"auto, (max-width: 1018px) 100vw, 1018px\" \/><\/p>\n<p style=\"text-align: justify;\">Na figura fornecida voc\u00ea pode ver que as strings de cada c\u00e9lula s\u00e3o separadas pelo delimitador atribu\u00eddo, ou seja, um caractere de espa\u00e7o (\u201c\u201c). Al\u00e9m disso, voc\u00ea pode fazer uso do caractere especial usando a fun\u00e7\u00e3o CHAR ou usando mais de um caractere.<\/p>\n<h2 style=\"text-align: left;\"><strong>Por que TEXTJOIN n\u00e3o funciona no Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Por tr\u00e1s da ocorr\u00eancia da f\u00f3rmula textjoin n\u00e3o funcionar, os problemas do Excel s\u00e3o respons\u00e1veis pelos seguintes motivos.<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Se a sua fun\u00e7\u00e3o TEXTJOIN ultrapassar o limite de 32.767 caracteres, ela retornar\u00e1 o erro \u2018#VALUE!\u2019.<\/li>\n<li style=\"text-align: left;\">O erro \u2018#VALUE!\u2019 tamb\u00e9m ocorre quando seu aplicativo Excel n\u00e3o consegue identificar o delimitador como texto.<\/li>\n<li style=\"text-align: left;\">Por exemplo, se voc\u00ea atribuir caracteres n\u00e3o imprim\u00edveis como CHAR(0).<\/li>\n<li style=\"text-align: left;\">Esta <strong>fun\u00e7\u00e3o TEXTJOIN<\/strong> tem um limite de 252 argumentos de texto.<\/li>\n<li style=\"text-align: left;\">Sua fun\u00e7\u00e3o alternativa \u00e9 CONCAT. A \u00fanica diferen\u00e7a entre essas duas fun\u00e7\u00f5es \u00e9 que CONCAT n\u00e3o aceita delimitador enquanto TEXTJOIN aceita delimitador.<\/li>\n<li style=\"text-align: left;\">#NOME? O erro geralmente ocorre quando voc\u00ea tenta usar esta fun\u00e7\u00e3o em uma vers\u00e3o mais antiga do Excel.<\/li>\n<li style=\"text-align: left;\">Entre as strings combinadas, se voc\u00ea esquecer de fornecer um valor comum, ent\u00e3o <strong>#NULL!<\/strong> ocorreu um erro.<\/li>\n<\/ul>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Leia tamb\u00e9m<\/span>: <a href=\"https:\/\/pt.repairmsexcel.com\/blog\/transpor-funcao-nao-trabalhando-no-excel\" target=\"_blank\" rel=\"noopener\">Corrigir problema de fun\u00e7\u00e3o de transposi\u00e7\u00e3o do Excel que n\u00e3o funciona<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Como corrigir o problema do Excel TEXTJOIN que n\u00e3o funciona?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Siga os m\u00e9todos passo a passo para superar esta situa\u00e7\u00e3o.<\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 1 \u2013 Use a alternativa da fun\u00e7\u00e3o TEXTJOIN<\/strong><\/h3>\n<p style=\"text-align: justify;\">Se a <strong>fun\u00e7\u00e3o TEXTJOIN do Excel n\u00e3o<\/strong> estiver funcionando, mas voc\u00ea precisar us\u00e1-la com urg\u00eancia, nesse caso, voc\u00ea poder\u00e1 usar a op\u00e7\u00e3o alternativa, ou seja, a fun\u00e7\u00e3o <strong>CONCAT<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Esta fun\u00e7\u00e3o oferece os mesmos recursos de <strong>CONCATENATE<\/strong>. Est\u00e1 habilitado para minimizar o comprimento do nome da fun\u00e7\u00e3o e seus argumentos.<\/p>\n<p style=\"text-align: justify;\">Embora a fun\u00e7\u00e3o CONCAT seja a substitui\u00e7\u00e3o de CONCATENATE. Ele est\u00e1 dispon\u00edvel em todos os aplicativos Excel\/Office mais recentes para oferecer compatibilidade com vers\u00f5es anteriores inteiras.<\/p>\n<p style=\"text-align: justify;\">Aqui est\u00e1 a sintaxe explicada abaixo:<\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><strong>CONCAT(text1, [text2],\u2026)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\"><strong>[text1]:<\/strong><\/p>\n<p style=\"text-align: justify;\">Voc\u00ea precisa especificar o intervalo de texto ou entrada de c\u00e9lulas unidas.<\/p>\n<p style=\"text-align: justify;\"><strong>\u00a0 [text2]:<\/strong><\/p>\n<p style=\"text-align: justify;\">Neste, voc\u00ea precisa atribuir intervalos para mesclar textos quando o intervalo n\u00e3o for cont\u00ednuo.<\/p>\n<p style=\"text-align: justify;\"><strong>Observa\u00e7\u00e3o<\/strong>:<\/p>\n<p style=\"text-align: justify;\">Esta op\u00e7\u00e3o tamb\u00e9m est\u00e1 dispon\u00edvel no Mac ou Windows se voc\u00ea for um usu\u00e1rio do Office 2019 ou se tiver uma assinatura do Office 365.<\/p>\n<p style=\"text-align: justify;\"><strong>Exemplo<\/strong>:<\/p>\n<p style=\"text-align: justify;\">Abaixo, a figura abaixo ajudar\u00e1 voc\u00ea a ter uma ideia clara de como a fun\u00e7\u00e3o <strong>CONCAT<\/strong> realmente funciona na mesclagem de todas as strings nas refer\u00eancias de c\u00e9lulas alocadas.<\/p>\n<p style=\"text-align: justify;\">Voc\u00ea n\u00e3o precisa escolher cada c\u00e9lula individualmente. Especificar o intervalo permitir\u00e1 que a fun\u00e7\u00e3o mescle as strings sem usar nenhum tipo de separador<\/p>\n<p style=\"text-align: justify;\">Se for necess\u00e1rio colocar os separadores, ent\u00e3o esta fun\u00e7\u00e3o <strong>CONCAT<\/strong> funciona exatamente da mesma maneira que a fun\u00e7\u00e3o <strong>CONCATENATE<\/strong> antiga funciona.<\/p>\n<p style=\"text-align: justify;\">Basta verificar a primeira e a segunda linhas na figura abaixo:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4723 aligncenter\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/2.png\" alt=\"Excel TEXTJOIN n\u00e3o funciona\" width=\"1277\" height=\"333\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/2.png 1277w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/2-768x200.png 768w\" sizes=\"auto, (max-width: 1277px) 100vw, 1277px\" \/><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 2 \u2013 Unir texto com condi\u00e7\u00f5es<\/strong><\/h3>\n<p style=\"text-align: justify;\">A fun\u00e7\u00e3o TEXTJOIN do Excel tem a capacidade de lidar facilmente com matrizes de strings. Portanto, voc\u00ea tamb\u00e9m pode us\u00e1-lo para mesclar condicionalmente dois ou mais conte\u00fados de c\u00e9lulas.<\/p>\n<p style=\"text-align: justify;\">Para fazer isso, voc\u00ea precisa usar a fun\u00e7\u00e3o SE para avaliar os intervalos de c\u00e9lulas. Tamb\u00e9m para retornar a matriz de valores que correspondem \u00e0 condi\u00e7\u00e3o com o argumento text1 do TEXTJOIN.<\/p>\n<p style=\"text-align: justify;\">Da figura mostrada, se voc\u00ea deseja extrair a lista dos membros da Equipe 1. Nesse caso, voc\u00ea precisa aninhar a instru\u00e7\u00e3o IF no argumento text1:<\/p>\n<p style=\"text-align: justify;\"><strong>IF($B$2:$B$9=1, $A$2:$A$9, \u201c\u201d)<\/strong><\/p>\n<p style=\"text-align: justify;\">Em um significado simples, a f\u00f3rmula acima afirma que: se a coluna B = 1, ent\u00e3o retorna o valor da coluna A da mesma linha. Ou ent\u00e3o apenas retorne a string vazia.<\/p>\n<p style=\"text-align: justify;\">Toda a f\u00f3rmula para a Equipe 1 ser\u00e1 assim:<\/p>\n<p style=\"text-align: justify;\"><strong>=TEXTJOIN(\u201c, \u201c, TRUE, IF($B$2:$B$9=1, $A$2:$A$9, \u201c\u201d))<\/strong><\/p>\n<p style=\"text-align: justify;\">Da mesma maneira, voc\u00ea pode obter facilmente uma lista separada por v\u00edrgulas dos membros da Equipe 2:<\/p>\n<p style=\"text-align: justify;\"><strong>=TEXTJOIN(\u201c, \u201c, TRUE, IF($B$2:$B$9=2, $A$2:$A$9, \u201c\u201d))<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4724 aligncenter\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/3.png\" alt=\"Excel TEXTJOIN n\u00e3o funciona\" width=\"486\" height=\"238\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #ff0000;\"><strong>Observa\u00e7\u00e3o<\/strong><\/span>.<\/p>\n<p style=\"text-align: justify;\">Como o recurso de matriz din\u00e2mica est\u00e1 bem implementado na vers\u00e3o mais recente do Office 365. Portanto, funciona como uma f\u00f3rmula normal, conforme mostrado na figura.<\/p>\n<p style=\"text-align: justify;\">Considerando que, no Excel 2019 voc\u00ea deve digitar a f\u00f3rmula de matriz tradicional junto com isso, n\u00e3o se esque\u00e7a de continuar pressionando o atalho <strong>Ctrl + Shift + Enter<\/strong>.<\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 3 \u2013 Converter coluna em lista separada por v\u00edrgula<\/strong><\/h3>\n<p style=\"text-align: justify;\">Voc\u00ea deve tentar concatenar a lista vertical e separar seu valor com ponto e v\u00edrgula, v\u00edrgula ou qualquer outro delimitador.<\/p>\n<p style=\"text-align: justify;\">Por exemplo, suponha que voc\u00ea esteja concatenando as derrotas ou vit\u00f3rias de cada equipe de uma determinada tabela. voc\u00ea precisa usar a seguinte f\u00f3rmula em que a \u00fanica diferen\u00e7a est\u00e1 nos intervalos de c\u00e9lulas que est\u00e3o sendo unidos.<\/p>\n<p style=\"text-align: justify;\">Para a equipe 1:<\/p>\n<p style=\"text-align: justify;\"><strong>=TEXTJOIN(\u201c,\u201d, FALSE, B2:B6)<\/strong><\/p>\n<p style=\"text-align: justify;\">Para a equipe 2:<\/p>\n<p style=\"text-align: justify;\"><strong>=TEXTJOIN(\u201c,\u201d, FALSE, C2:C6)<\/strong><\/p>\n<p style=\"text-align: justify;\">E assim por diante.<\/p>\n<p style=\"text-align: justify;\">Em todas as f\u00f3rmulas fornecidas acima, os seguintes argumentos s\u00e3o usados:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\"><em>Delimitador \u2013 uma v\u00edrgula (\u201c\u201d,).<\/em><\/li>\n<li style=\"text-align: left;\"><em> Para incluir a c\u00e9lula vazia, Ignore_empty deve ser definido como FALSE. Como aqui, precisamos mostrar quais jogos n\u00e3o s\u00e3o disputados.<\/em><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Assim, como resultado, voc\u00ea obter\u00e1 4 listas separadas por v\u00edrgulas que representam as derrotas e vit\u00f3rias de cada equipe na forma compacta:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4725 aligncenter\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/4.png\" alt=\"Excel TEXTJOIN n\u00e3o funciona\" width=\"620\" height=\"178\" \/><\/p>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Leia tamb\u00e9m<\/span>: <a href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-trim-funcao-nao-trabalhando\" target=\"_blank\" rel=\"noopener\">Corrigir problema de fun\u00e7\u00e3o TRIM do Excel que n\u00e3o funciona<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Perguntas frequentes relacionadas:<\/strong><\/h2>\n<h4 style=\"text-align: left;\"><strong>Qual \u00e9 a alternativa para a fun\u00e7\u00e3o Textjoin?<\/strong><\/h4>\n<p style=\"text-align: justify;\">A alternativa \u00e0 fun\u00e7\u00e3o TEXTJOIN \u00e9 CONCAT.<\/p>\n<h4 style=\"text-align: left;\"><strong>Como posso concatenar texto de c\u00e9lulas n\u00e3o cont\u00edguas usando TEXTJOIN?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Para concatenar texto de c\u00e9lulas n\u00e3o cont\u00edguas, voc\u00ea pode usar uma f\u00f3rmula de matriz junto com TEXTJOIN. Selecione o intervalo de c\u00e9lulas que cont\u00e9m o texto, coloque-o entre chaves e use-o como argumento em TEXTJOIN.<\/p>\n<h4 style=\"text-align: left;\"><strong>Qual \u00e9 a limita\u00e7\u00e3o do Textjoin no Excel?<\/strong><\/h4>\n<p style=\"text-align: justify;\">A limita\u00e7\u00e3o do Textjoin no Excel pode lidar com at\u00e9 252 argumentos de texto.<\/p>\n<h4 style=\"text-align: left;\"><strong>TEXTJOIN pode lidar com texto contendo caracteres especiais?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Sim, TEXTJOIN pode lidar com texto contendo caracteres especiais. Por\u00e9m, certifique-se de que o delimitador usado em TEXTJOIN n\u00e3o entre em conflito com nenhum caractere especial presente no texto.<\/p>\n<h2 style=\"text-align: left;\"><strong>Pensamentos finais<\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong>TEXTJOIN n\u00e3o funcionar no Excel<\/strong> pode ser um problema frustrante, mas com a abordagem certa, \u00e9 totalmente administr\u00e1vel. No entanto, seguindo as solu\u00e7\u00f5es descritas neste blog, voc\u00ea pode solucionar esse problema de forma eficaz, garantindo um bom funcionamento e resultados precisos em suas planilhas Excel.<\/p>\n<p style=\"text-align: justify;\">Espero que voc\u00ea tenha gostado de ler este post.<\/p>\n<br><center><a href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><img class='pt-cta-729' src='https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-pt.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Como todos sabemos, o Microsoft Excel vem com v\u00e1rios recursos, f\u00f3rmulas e fun\u00e7\u00f5es. A fun\u00e7\u00e3o TEXTJOIN \u00e9 uma delas. \u00c9 &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Excel TEXTJOIN n\u00e3o funciona? Descubra a solu\u00e7\u00e3o aqui!\" class=\"read-more button\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando#more-2203\" aria-label=\"Read more about Excel TEXTJOIN n\u00e3o funciona? Descubra a solu\u00e7\u00e3o aqui!\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":2211,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[694],"tags":[1488,1487,1486],"class_list":["post-2203","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-erros","tag-a-funcao-excel-textjoin-nao-esta-funcionando","tag-corrija-o-excel-textjoin-que-nao-funciona","tag-textjoin-nao-funciona-no-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel TEXTJOIN n\u00e3o funciona? Descubra a solu\u00e7\u00e3o aqui!<\/title>\n<meta name=\"description\" content=\"Voc\u00ea est\u00e1 enfrentando problemas com o Excel TEXTJOIN que n\u00e3o funciona? N\u00e3o procure mais! Saiba por que esse problema surge e como corrigi-lo sem esfor\u00e7o.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel TEXTJOIN n\u00e3o funciona? Descubra a solu\u00e7\u00e3o aqui!\" \/>\n<meta property=\"og:description\" content=\"Voc\u00ea est\u00e1 enfrentando problemas com o Excel TEXTJOIN que n\u00e3o funciona? N\u00e3o procure mais! Saiba por que esse problema surge e como corrigi-lo sem esfor\u00e7o.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando\" \/>\n<meta property=\"og:site_name\" content=\"Excel Arquivo Reparar Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-11T07:04:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-11T13:00:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/excel-TEXTJOIN-Function-not-working-pt.png\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"540\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Margret\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/margret1_arthur\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Margret\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-textjoin-funcao-nao-trabalhando#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-textjoin-funcao-nao-trabalhando\"},\"author\":{\"name\":\"Margret\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\"},\"headline\":\"Excel TEXTJOIN n\u00e3o funciona? Descubra a solu\u00e7\u00e3o aqui!\",\"datePublished\":\"2024-05-11T07:04:28+00:00\",\"dateModified\":\"2024-05-11T13:00:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-textjoin-funcao-nao-trabalhando\"},\"wordCount\":1406,\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-textjoin-funcao-nao-trabalhando#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/excel-TEXTJOIN-Function-not-working-pt.png\",\"keywords\":[\"a fun\u00e7\u00e3o Excel TEXTJOIN n\u00e3o est\u00e1 funcionando\",\"corrija o Excel TEXTJOIN que n\u00e3o funciona\",\"TEXTJOIN n\u00e3o funciona no Excel\"],\"articleSection\":[\"Excel erros\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-textjoin-funcao-nao-trabalhando\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-textjoin-funcao-nao-trabalhando\",\"name\":\"Excel TEXTJOIN n\u00e3o funciona? Descubra a solu\u00e7\u00e3o aqui!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-textjoin-funcao-nao-trabalhando#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-textjoin-funcao-nao-trabalhando#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/excel-TEXTJOIN-Function-not-working-pt.png\",\"datePublished\":\"2024-05-11T07:04:28+00:00\",\"dateModified\":\"2024-05-11T13:00:26+00:00\",\"description\":\"Voc\u00ea est\u00e1 enfrentando problemas com o Excel TEXTJOIN que n\u00e3o funciona? N\u00e3o procure mais! Saiba por que esse problema surge e como corrigi-lo sem esfor\u00e7o.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-textjoin-funcao-nao-trabalhando#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-textjoin-funcao-nao-trabalhando\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-textjoin-funcao-nao-trabalhando#primaryimage\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/excel-TEXTJOIN-Function-not-working-pt.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/excel-TEXTJOIN-Function-not-working-pt.png\",\"width\":960,\"height\":540,\"caption\":\"3 maneiras de corrigir Excel Textjoin fun\u00e7\u00e3o N\u00e3o Trabalhando Problema\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-textjoin-funcao-nao-trabalhando#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel TEXTJOIN n\u00e3o funciona? Descubra a solu\u00e7\u00e3o aqui!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Excel Arquivo Reparar Blog\",\"description\":\"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas\",\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Excel Arquivo Reparar\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Excel Arquivo Reparar\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\",\"name\":\"Margret\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"caption\":\"Margret\"},\"description\":\"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/margret-arthur-2545b6195\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/margret1_arthur\"],\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/author\\\/margret\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel TEXTJOIN n\u00e3o funciona? Descubra a solu\u00e7\u00e3o aqui!","description":"Voc\u00ea est\u00e1 enfrentando problemas com o Excel TEXTJOIN que n\u00e3o funciona? N\u00e3o procure mais! Saiba por que esse problema surge e como corrigi-lo sem esfor\u00e7o.","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:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando","og_locale":"en_US","og_type":"article","og_title":"Excel TEXTJOIN n\u00e3o funciona? Descubra a solu\u00e7\u00e3o aqui!","og_description":"Voc\u00ea est\u00e1 enfrentando problemas com o Excel TEXTJOIN que n\u00e3o funciona? N\u00e3o procure mais! Saiba por que esse problema surge e como corrigi-lo sem esfor\u00e7o.","og_url":"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando","og_site_name":"Excel Arquivo Reparar Blog","article_published_time":"2024-05-11T07:04:28+00:00","article_modified_time":"2024-05-11T13:00:26+00:00","og_image":[{"width":960,"height":540,"url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/excel-TEXTJOIN-Function-not-working-pt.png","type":"image\/png"}],"author":"Margret","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/margret1_arthur","twitter_misc":{"Written by":"Margret","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando#article","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando"},"author":{"name":"Margret","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca"},"headline":"Excel TEXTJOIN n\u00e3o funciona? Descubra a solu\u00e7\u00e3o aqui!","datePublished":"2024-05-11T07:04:28+00:00","dateModified":"2024-05-11T13:00:26+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando"},"wordCount":1406,"publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/excel-TEXTJOIN-Function-not-working-pt.png","keywords":["a fun\u00e7\u00e3o Excel TEXTJOIN n\u00e3o est\u00e1 funcionando","corrija o Excel TEXTJOIN que n\u00e3o funciona","TEXTJOIN n\u00e3o funciona no Excel"],"articleSection":["Excel erros"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando","url":"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando","name":"Excel TEXTJOIN n\u00e3o funciona? Descubra a solu\u00e7\u00e3o aqui!","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando#primaryimage"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/excel-TEXTJOIN-Function-not-working-pt.png","datePublished":"2024-05-11T07:04:28+00:00","dateModified":"2024-05-11T13:00:26+00:00","description":"Voc\u00ea est\u00e1 enfrentando problemas com o Excel TEXTJOIN que n\u00e3o funciona? N\u00e3o procure mais! Saiba por que esse problema surge e como corrigi-lo sem esfor\u00e7o.","breadcrumb":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando#primaryimage","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/excel-TEXTJOIN-Function-not-working-pt.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/excel-TEXTJOIN-Function-not-working-pt.png","width":960,"height":540,"caption":"3 maneiras de corrigir Excel Textjoin fun\u00e7\u00e3o N\u00e3o Trabalhando Problema"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-textjoin-funcao-nao-trabalhando#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Excel TEXTJOIN n\u00e3o funciona? Descubra a solu\u00e7\u00e3o aqui!"}]},{"@type":"WebSite","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website","url":"https:\/\/pt.repairmsexcel.com\/blog\/","name":"Excel Arquivo Reparar Blog","description":"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas","publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pt.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization","name":"Excel Arquivo Reparar","url":"https:\/\/pt.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Excel Arquivo Reparar"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca","name":"Margret","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","caption":"Margret"},"description":"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.","sameAs":["https:\/\/www.linkedin.com\/in\/margret-arthur-2545b6195\/","https:\/\/x.com\/https:\/\/twitter.com\/margret1_arthur"],"url":"https:\/\/pt.repairmsexcel.com\/blog\/author\/margret"}]}},"_links":{"self":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=2203"}],"version-history":[{"count":7,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2203\/revisions"}],"predecessor-version":[{"id":4726,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2203\/revisions\/4726"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/2211"}],"wp:attachment":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=2203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=2203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=2203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}