{"id":11165,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/compactar\/"},"modified":"2021-02-25T17:31:57","modified_gmt":"2021-02-25T17:31:57","slug":"trim","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/trim\/","title":{"rendered":"COMPACTAR"},"content":{"rendered":"

Introdu\u00e7\u00e3o<\/h2>\n

A fun\u00e7\u00e3o TRIM (chamada de COMPACTAR em vers\u00f5es de Excel em portugu\u00eas) \u00e9 amplamente utilizada tanto no Microsoft Excel quanto no Google Sheets para eliminar espa\u00e7os excessivos em uma string, exceto por um \u00fanico espa\u00e7o entre palavras. Essa fun\u00e7\u00e3o \u00e9 particularmente valiosa para a limpeza de dados importados ou na prepara\u00e7\u00e3o de texto para an\u00e1lises.<\/p>\n

Sintaxe e Exemplos<\/h2>\n

A sintaxe da fun\u00e7\u00e3o COMPACTAR \u00e9 bastante simples:<\/p>\n

=COMPACTAR(texto)<\/code><\/pre>\n
Onde texto<\/i> \u00e9 a string da qual se deseja eliminar os espa\u00e7os extras.<\/p>\n
Exemplo b\u00e1sico no Excel e Google Sheets:<\/p>\n
    \n
  • Suponha que A1 cont\u00e9m a string ‘ Ol\u00e1 mundo! ‘.<\/li>\n
  • Ao aplicar a fun\u00e7\u00e3o COMPACTAR na c\u00e9lula B1: =COMPACTAR(A1)<\/code><\/li>\n
  • O resultado em B1 ser\u00e1 ‘Ol\u00e1 mundo!’<\/li>\n<\/ul>\n
    Casos Pr\u00e1ticos de Uso<\/h2>\n
    A fun\u00e7\u00e3o COMPACTAR pode ser extremamente \u00fatil em v\u00e1rias situa\u00e7\u00f5es pr\u00e1ticas:<\/p>\n
    1. Limpeza de Dados Importados<\/h2>\n
    Problema:<\/strong> Voc\u00ea recebeu um arquivo CSV com dados de contato onde o campo de nomes cont\u00e9m espa\u00e7os irregulares, prejudicando a padroniza\u00e7\u00e3o da base.<\/p>\n
    Solu\u00e7\u00e3o:<\/strong> Aplicar a fun\u00e7\u00e3o COMPACTAR para normalizar os nomes.<\/p>\n\n\n\n\n\n
    Nome Original<\/th>\nNome Compactado<\/th>\n<\/tr>\n
    ‘ Jo\u00e3o Santos ‘<\/td>\n=COMPACTAR(A2)<\/code><\/td>\n<\/tr>\n
    ‘Ana Maria’<\/td>\n=COMPACTAR(A3)<\/code><\/td>\n<\/tr>\n
    ‘ Luciano Souza ‘<\/td>\n=COMPACTAR(A4)<\/code><\/td>\n<\/tr>\n<\/table>\n
    Aplicando a fun\u00e7\u00e3o em cada c\u00e9lula, os nomes ser\u00e3o formatados corretamente sem espa\u00e7os extras.<\/p>\n
    2. Prepara\u00e7\u00e3o de Texto para An\u00e1lises<\/h2>\n
    Problema:<\/strong> Voc\u00ea precisa preparar dados textuais para an\u00e1lise e deseja assegurar que n\u00e3o haja distor\u00e7\u00f5es causadas por espa\u00e7os m\u00faltiplos.<\/p>\n
    Solu\u00e7\u00e3o:<\/strong> Utilizar a fun\u00e7\u00e3o COMPACTAR para uniformizar os espa\u00e7os.<\/p>\n
    =COMPACTAR(\"An\u00e1lise de dados em Excel e Google Sheets\")<\/code><\/pre>\n
    Ao aplicar a fun\u00e7\u00e3o COMPACTAR, o texto ser\u00e1 transformado para ‘An\u00e1lise de dados em Excel e Google Sheets’, garantindo que an\u00e1lises que dependam de contagem de palavras ou outros m\u00e9todos n\u00e3o sejam afetadas por espa\u00e7os indevidos.<\/p>\n
    Conclus\u00e3o<\/h2>\n
    O uso da fun\u00e7\u00e3o COMPACTAR \u00e9 essencial para a prepara\u00e7\u00e3o e limpeza de dados em textos, facilitando o trabalho de an\u00e1lise e garantindo a qualidade da informa\u00e7\u00e3o tratada. Seja removendo espa\u00e7os desnecess\u00e1rios em listas de endere\u00e7os ou preparando dados para relat\u00f3rios, essa fun\u00e7\u00e3o simples mas poderosa \u00e9 uma ferramenta indispens\u00e1vel no arsenal de qualquer usu\u00e1rio de Excel e Google Sheets.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Remove espa\u00e7os do texto<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[441],"tags":[],"class_list":["post-11165","post","type-post","status-publish","format-standard","hentry","category-texto"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o TRIM (COMPACTAR) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o TRIM (COMPACTAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/pt-pt\/trim\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o TRIM (COMPACTAR) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o TRIM (COMPACTAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/trim\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:31:57+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o TRIM (COMPACTAR) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/trim\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/trim\/\",\"name\":\"Fun\u00e7\u00e3o TRIM (COMPACTAR) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:50+00:00\",\"dateModified\":\"2021-02-25T17:31:57+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o TRIM (COMPACTAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/trim\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/trim\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/trim\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Texto\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/texto\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"COMPACTAR\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o TRIM (COMPACTAR) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o TRIM (COMPACTAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","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:\/\/functiontranslator.com\/pt-pt\/trim\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o TRIM (COMPACTAR) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o TRIM (COMPACTAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/trim\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:31:57+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o TRIM (COMPACTAR) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/trim\/","url":"https:\/\/functiontranslator.com\/pt-pt\/trim\/","name":"Fun\u00e7\u00e3o TRIM (COMPACTAR) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:50+00:00","dateModified":"2021-02-25T17:31:57+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o TRIM (COMPACTAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/trim\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/trim\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/trim\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Texto","item":"https:\/\/functiontranslator.com\/pt-pt\/texto\/"},{"@type":"ListItem","position":3,"name":"COMPACTAR"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11165","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=11165"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11165\/revisions"}],"predecessor-version":[{"id":25994,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11165\/revisions\/25994"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=11165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=11165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=11165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}