{"id":1300,"date":"2024-07-29T14:01:06","date_gmt":"2024-07-29T14:01:06","guid":{"rendered":"https:\/\/www.fpw.com.br\/?p=1300"},"modified":"2025-01-23T19:14:40","modified_gmt":"2025-01-23T19:14:40","slug":"excel-funcao-arrumar-com-alguns-truques","status":"publish","type":"post","link":"https:\/\/fpw.com.br\/m\/excel-funcao-arrumar-com-alguns-truques\/","title":{"rendered":"Excel | Fun\u00e7\u00e3o ARRUMAR com alguns truques"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1300\" class=\"elementor elementor-1300\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-76c1340 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"76c1340\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-40b0655 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"40b0655\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-3c6add9 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"3c6add9\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a7f66c1 elementor-widget elementor-widget-heading\" data-id=\"a7f66c1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Fun\u00e7\u00e3o ARRUMAR com alguns truques<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b6fbbe7 elementor-widget elementor-widget-text-editor\" data-id=\"b6fbbe7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h6>Est\u00e1 p\u00e1gina cont\u00e9m links patrocinados!<\/h6><h2>Introdu\u00e7\u00e3o \u00e0 Fun\u00e7\u00e3o ARRUMAR no Excel<\/h2><p>A fun\u00e7\u00e3o ARRUMAR no Excel \u00e9 utilizada para remover espa\u00e7os extras de um texto, deixando apenas um espa\u00e7o simples entre as palavras. Esta fun\u00e7\u00e3o \u00e9 especialmente \u00fatil quando se trabalha com dados importados de outras fontes, onde a formata\u00e7\u00e3o do texto pode n\u00e3o estar consistente.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-621913e elementor-widget elementor-widget-text-editor\" data-id=\"621913e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h2>Como Usar a Fun\u00e7\u00e3o ARRUMAR<\/h2><p>O uso da fun\u00e7\u00e3o ARRUMAR \u00e9 bastante simples. A sua sintaxe \u00e9:<\/p><p><strong>=ARRUMAR(texto)<\/strong><\/p><p>Onde\u00a0<strong>texto<\/strong>\u00a0\u00e9 a c\u00e9lula ou cadeia de caracteres que voc\u00ea deseja arrumar. Por exemplo, se voc\u00ea tem a frase &#8216; Ol\u00e1 Mundo &#8216; na c\u00e9lula A1, ao utilizar\u00a0<strong>=ARRUMAR(A1)<\/strong>, o resultado ser\u00e1 &#8216;Ol\u00e1 Mundo&#8217;.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-345f586 elementor-widget elementor-widget-video\" data-id=\"345f586\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=6jV-TGOoD6c&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be147cd elementor-widget elementor-widget-text-editor\" data-id=\"be147cd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h2>Exemplos Pr\u00e1ticos<\/h2><p>Vamos considerar alguns exemplos pr\u00e1ticos para entender melhor como a fun\u00e7\u00e3o ARRUMAR pode melhorar a qualidade dos seus dados.<\/p><h3>Exemplo 1: Limpeza de Dados Importados<\/h3><p>Imagine que voc\u00ea importou uma lista de nomes para o Excel e eles est\u00e3o cheios de espa\u00e7os extras. A lista est\u00e1 na coluna A:<\/p><p><em>Jo\u00e3o<\/em><\/p><p><em>Maria<\/em><\/p><p><em>Carlos<\/em><\/p><p>Para limpar esses dados, voc\u00ea pode usar a fun\u00e7\u00e3o ARRUMAR nas c\u00e9lulas da coluna B:<\/p><p><strong>=ARRUMAR(A1)<\/strong><\/p><p>Ao arrastar a f\u00f3rmula para baixo, a coluna B ser\u00e1 preenchida com os nomes corrigidos, sem espa\u00e7os extras:<\/p><p><em>Jo\u00e3o<\/em><\/p><p><em>Maria<\/em><\/p><p><em>Carlos<\/em><\/p><h3>Exemplo 2: Combina\u00e7\u00e3o com Outras Fun\u00e7\u00f5es<\/h3><p>A fun\u00e7\u00e3o ARRUMAR pode ser combinada com outras fun\u00e7\u00f5es para aumentar ainda mais a sua utilidade. Por exemplo, se voc\u00ea quiser concatenar (juntar) duas c\u00e9lulas, mas garantir que n\u00e3o haja espa\u00e7os extras, voc\u00ea pode fazer o seguinte:<\/p><p><strong>=CONCATENAR(ARRUMAR(A1), ARRUMAR(B1))<\/strong><\/p><p>Isso garante que o texto concatenado esteja livre de espa\u00e7os indesejados.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1c0c2b4 elementor-widget elementor-widget-text-editor\" data-id=\"1c0c2b4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h2>Conclus\u00e3o<\/h2><p>A fun\u00e7\u00e3o ARRUMAR \u00e9 uma ferramenta poderosa no arsenal do Excel, especialmente quando se lida com dados importados ou mal formatados. Ao entender e aplicar esta fun\u00e7\u00e3o, voc\u00ea pode garantir que seus dados estejam sempre limpos e uniformes, facilitando a an\u00e1lise e apresenta\u00e7\u00e3o dos mesmos.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2b4987b elementor-widget elementor-widget-image\" data-id=\"2b4987b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"680\" height=\"544\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/07\/funcao-arrumar.jpg\" class=\"attachment-large size-large wp-image-1301\" alt=\"Fun\u00e7\u00e3o ARRUMAR com alguns truques\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/07\/funcao-arrumar.jpg 680w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/07\/funcao-arrumar-300x240.jpg 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/07\/funcao-arrumar-600x480.jpg 600w\" sizes=\"(max-width: 680px) 100vw, 680px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c4ea7cd e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"c4ea7cd\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0496a0b elementor-widget elementor-widget-html\" data-id=\"0496a0b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-9545756132587918\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- Post Quadrado 2 -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-9545756132587918\"\r\n     data-ad-slot=\"1542008967\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fa85d6f wpr-grid-columns-3 wpr-grid-columns--tablet2 wpr-grid-columns--mobile1 wpr-item-styles-inner elementor-widget elementor-widget-wpr-grid\" data-id=\"fa85d6f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"wpr-grid.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"wpr-grid-filters elementor-clearfix wpr-grid-filters-sep-right\"><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span  data-filter=\"*\" class=\"wpr-grid-filters-item wpr-active-filter \">All Posts<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"blog\"]  data-filter=\".category-blog\">Blog<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"certificados\"]  data-filter=\".category-certificados\">Certificados<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"dados\"]  data-filter=\".category-dados\">Dados<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"dashboard\"]  data-filter=\".category-dashboard\">Dashboard<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"diversos\"]  data-filter=\".category-diversos\">Diversos<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"excel\"]  data-filter=\".category-excel\">Excel<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"fpw\"]  data-filter=\".category-fpw\">FPw<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"membros\"]  data-filter=\".category-membros\">Membros<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"noticias\"]  data-filter=\".category-noticias\">Not\u00c3\u00adcias<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"planilhas\"]  data-filter=\".category-planilhas\">Planilhas<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"produtos\"]  data-filter=\".category-produtos\">Produtos<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"sql\"]  data-filter=\".category-sql\">SQL<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"tecnologia\"]  data-filter=\".category-tecnologia\">Tecnologia<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"wordpress\"]  data-filter=\".category-wordpress\">WordPress<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><\/ul><section class=\"wpr-grid elementor-clearfix\" data-settings=\"{&quot;layout&quot;:&quot;fitRows&quot;,&quot;stick_last_element_to_bottom&quot;:&quot;&quot;,&quot;columns_desktop&quot;:3,&quot;gutter_hr&quot;:15,&quot;gutter_hr_mobile&quot;:15,&quot;gutter_hr_mobile_extra&quot;:15,&quot;gutter_hr_tablet&quot;:15,&quot;gutter_hr_tablet_extra&quot;:15,&quot;gutter_hr_laptop&quot;:15,&quot;gutter_hr_widescreen&quot;:15,&quot;gutter_vr&quot;:15,&quot;gutter_vr_mobile&quot;:15,&quot;gutter_vr_mobile_extra&quot;:15,&quot;gutter_vr_tablet&quot;:15,&quot;gutter_vr_tablet_extra&quot;:15,&quot;gutter_vr_laptop&quot;:15,&quot;gutter_vr_widescreen&quot;:15,&quot;animation&quot;:&quot;default&quot;,&quot;animation_duration&quot;:0.3,&quot;animation_delay&quot;:0.1,&quot;deeplinking&quot;:&quot;&quot;,&quot;filters_linkable&quot;:&quot;no&quot;,&quot;filters_default_filter&quot;:&quot;&quot;,&quot;filters_count&quot;:&quot;&quot;,&quot;filters_hide_empty&quot;:&quot;no&quot;,&quot;filters_animation&quot;:&quot;default&quot;,&quot;filters_animation_duration&quot;:0.3,&quot;filters_animation_delay&quot;:0.1,&quot;pagination_type&quot;:&quot;load-more&quot;,&quot;pagination_max_pages&quot;:114,&quot;lightbox&quot;:{&quot;selector&quot;:&quot;.wpr-grid-image-wrap&quot;,&quot;iframeMaxWidth&quot;:&quot;60%&quot;,&quot;hash&quot;:false,&quot;autoplay&quot;:&quot;true&quot;,&quot;pause&quot;:5000,&quot;progressBar&quot;:&quot;true&quot;,&quot;counter&quot;:&quot;true&quot;,&quot;controls&quot;:&quot;true&quot;,&quot;getCaptionFromTitleOrAlt&quot;:&quot;true&quot;,&quot;thumbnail&quot;:&quot;&quot;,&quot;showThumbByDefault&quot;:&quot;&quot;,&quot;share&quot;:&quot;&quot;,&quot;zoom&quot;:&quot;true&quot;,&quot;fullScreen&quot;:&quot;true&quot;,&quot;download&quot;:&quot;true&quot;}}\" data-advanced-filters=\"no\"><article class=\"wpr-grid-item elementor-clearfix post-9770 post type-post status-publish format-standard has-post-thumbnail hentry category-dados tag-dados tag-sql\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Sua-empresa-provavelmente-nao-sofre-de-falta-de-dados.jpg\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Sua-empresa-provavelmente-nao-sofre-de-falta-de-dados.jpg\" alt=\"Sua empresa provavelmente n\u00e3o sofre de falta de dados.\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/dados-sua-empresa-provavelmente-nao-sofre-de-falta-de-dados\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/dados-sua-empresa-provavelmente-nao-sofre-de-falta-de-dados\/\">Dados | Sua empresa provavelmente n\u00e3o sofre de falta de dados.<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/dados-sua-empresa-provavelmente-nao-sofre-de-falta-de-dados\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><article class=\"wpr-grid-item elementor-clearfix post-9754 post type-post status-publish format-standard has-post-thumbnail hentry category-dashboard\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/3-erros-que-fazem-um-Dashboard-Financeiro-parecer-profissional.jpg\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/3-erros-que-fazem-um-Dashboard-Financeiro-parecer-profissional.jpg\" alt=\"3 erros que fazem um Dashboard Financeiro parecer profissional\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/dashboard-3-erros-que-fazem-um-dashboard-financeiro-parecer-profissional-mas-entregar-decisoes-ruins\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/dashboard-3-erros-que-fazem-um-dashboard-financeiro-parecer-profissional-mas-entregar-decisoes-ruins\/\">Dashboard | 3 erros que fazem um Dashboard Financeiro parecer profissional \u2014 mas entregar decis\u00f5es ruins<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/dashboard-3-erros-que-fazem-um-dashboard-financeiro-parecer-profissional-mas-entregar-decisoes-ruins\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><article class=\"wpr-grid-item elementor-clearfix post-9253 post type-post status-publish format-standard has-post-thumbnail hentry category-excel\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Erros-do-Excel-qual-a-diferenca-entre-ND-REF-e-os-outros-erros.jpg\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Erros-do-Excel-qual-a-diferenca-entre-ND-REF-e-os-outros-erros.jpg\" alt=\"Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/excel-erros-do-excel-qual-a-diferenca-entre-n-d-ref-e-os-outros-erros\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/excel-erros-do-excel-qual-a-diferenca-entre-n-d-ref-e-os-outros-erros\/\">Excel | Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros?<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/excel-erros-do-excel-qual-a-diferenca-entre-n-d-ref-e-os-outros-erros\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><\/section>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f61c64e wpr-pricing-table-animation-none wpr-pricing-table-heading-center elementor-widget elementor-widget-wpr-pricing-table\" data-id=\"f61c64e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"wpr-pricing-table.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\n\t<div class=\"wpr-pricing-table\">\n\t\t\n\t\t\t<div class=\"elementor-repeater-item-d174595 wpr-pricing-table-item wpr-pricing-table-heading wpr-pricing-table-item-first\">\t\t\n\t\t\t\n\t\t\t\n\t\t\t\t<div class=\"wpr-pricing-table-headding-inner\">\n\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"wpr-pricing-table-icon\">\n\t\t\t\t\t\t\t<i class=\"far fa-gem\"><\/i>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"wpr-pricing-table-title-wrap\">\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t<h3 class=\"wpr-pricing-table-title\">Cursos<\/h3>\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t<span class=\"wpr-pricing-table-sub-title\">Promo\u00e7\u00e3o<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\t\t\n\t\t\n\t\t\t\n\t\t\t<\/div>\n\t\t\t\n\t\t\t<div class=\"elementor-repeater-item-d49d49e wpr-pricing-table-item wpr-pricing-table-price\">\t\t\n\t\t\t\n\t\t\t\n\t\t\t\t<div class=\"wpr-pricing-table-price-inner\">\n\t\t\t\t\t\n\t\t\t\t\t<span class=\"wpr-pricing-table-currency\">R$<\/span>\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-pricing-table-main-price\">500<\/span>\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-pricing-table-sub-price\">00<\/span>\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\n\t\t\t\t\t<div class=\"wpr-pricing-table-preiod\">\/Ano<\/div>\n\t\t\t\t\t\t\n\t\t\t\n\t\t\t<\/div>\n\t\t\t\n\t\t\t<section class=\"elementor-repeater-item-76eab2a wpr-pricing-table-item wpr-pricing-table-feature\">\n\t\t\t\t<div class=\"wpr-pricing-table-feature-inner\">\n\t\t\t\t\t\t\t\t\t\t\t<i class=\"wpr-pricing-table-feature-icon fas fa-check\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t<span class=\"wpr-pricing-table-feature-text wpr-pricing-table-ftext-line-\">\n\t\t\t\t\t\t<span>\n\t\t\t\t\t\tExcel para todos\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/span>\n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t<\/div>\n\t\t\t<\/section>\n\n\t\t\t\n\t\t\t<section class=\"elementor-repeater-item-79373a6 wpr-pricing-table-item wpr-pricing-table-feature\">\n\t\t\t\t<div class=\"wpr-pricing-table-feature-inner\">\n\t\t\t\t\t\t\t\t\t\t\t<i class=\"wpr-pricing-table-feature-icon fas fa-check\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t<span class=\"wpr-pricing-table-feature-text wpr-pricing-table-ftext-line-\">\n\t\t\t\t\t\t<span>\n\t\t\t\t\t\tSQL do B\u00e1sico ao Avan\u00e7ado\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/span>\n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t<\/div>\n\t\t\t<\/section>\n\n\t\t\t\n\t\t\t<section class=\"elementor-repeater-item-f655bbf wpr-pricing-table-item wpr-pricing-table-feature\">\n\t\t\t\t<div class=\"wpr-pricing-table-feature-inner\">\n\t\t\t\t\t\t\t\t\t\t\t<i class=\"wpr-pricing-table-feature-icon fas fa-check\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t<span class=\"wpr-pricing-table-feature-text wpr-pricing-table-ftext-line-\">\n\t\t\t\t\t\t<span>\n\t\t\t\t\t\tFPw INtermedi\u00e1rio\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/span>\n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t<\/div>\n\t\t\t<\/section>\n\n\t\t\t\n\t\t\t<div class=\"elementor-repeater-item-702a29f wpr-pricing-table-item wpr-pricing-table-button\">\t\t\n\t\t\t\n\t\t\t\n\t\t\t\t<a class=\"wpr-pricing-table-btn wpr-button-effect wpr-button-none\" href=\"https:\/\/fpw.com.br\/ead\/todos-os-cursos\/\" target=\"_blank\" rel=\"noopener noreferrer\">\n\t\t\t\t\t<span>\n\n\t\t\t\t\t\t\n\t\t\t\t\t\tAcessar\n\t\t\t\t\t\t\n\t\t\t\t\t<\/span>\n\t\t\t\t<\/a>\n\t\t\t\t\n\t\t\t\n\t\t\t<\/div>\n\t\t\t\n\t\t\t<div class=\"elementor-repeater-item-d45bc4a wpr-pricing-table-item wpr-pricing-table-text wpr-pricing-table-item-last\">\t\t\n\t\t\t\n\t\t\t\n\t\t\t\tuseo Cupom VALE50 e tenha 50% de desconto!\n\t\t\t\n\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"wpr-pricing-table-badge wpr-pricing-table-badge-corner wpr-pricing-table-badge-right\">\t\n\t\t\t\t<div class=\"wpr-pricing-table-badge-inner\">Sale<\/div>\t\n\t\t\t<\/div>\n\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c171d27 wpr-author-box-arrange-vertical elementor-widget elementor-widget-wpr-author-box\" data-id=\"c171d27\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"wpr-author-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"wpr-author-box\"><div class=\"wpr-author-box-image\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/4d29370c4e3a80d286809ea97855951799d2f2ef82aa2bee944ce60205ad92b5?s=264&amp;d=mm&amp;r=g\" class=\"avatar avatar-264 photo\" height=\"264\" width=\"264\" \/><\/div><div class=\"wpr-author-box-text\"><h3 class=\"wpr-author-box-name\">Marco Chinarelli<\/h3><h3 class=\"wpr-author-box-title\">Writer &amp; Blogger<\/h3><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Fun\u00e7\u00e3o ARRUMAR com alguns truques Est\u00e1 p\u00e1gina cont\u00e9m links patrocinados! Introdu\u00e7\u00e3o \u00e0 Fun\u00e7\u00e3o ARRUMAR no Excel A fun\u00e7\u00e3o ARRUMAR no Excel \u00e9 utilizada para remover espa\u00e7os extras de um texto, deixando apenas um espa\u00e7o simples entre as palavras. Esta fun\u00e7\u00e3o \u00e9 especialmente \u00fatil quando se trabalha com dados importados de outras fontes, onde a formata\u00e7\u00e3o do texto pode n\u00e3o estar consistente. Como Usar a Fun\u00e7\u00e3o ARRUMAR O uso da fun\u00e7\u00e3o ARRUMAR \u00e9 bastante simples. A sua sintaxe \u00e9: =ARRUMAR(texto) Onde\u00a0texto\u00a0\u00e9 a c\u00e9lula ou cadeia de caracteres que voc\u00ea deseja arrumar. Por exemplo, se voc\u00ea tem a frase &#8216; Ol\u00e1 Mundo &#8216; na c\u00e9lula A1, ao utilizar\u00a0=ARRUMAR(A1), o resultado ser\u00e1 &#8216;Ol\u00e1 Mundo&#8217;. https:\/\/www.youtube.com\/watch?v=6jV-TGOoD6c Exemplos Pr\u00e1ticos Vamos considerar alguns exemplos pr\u00e1ticos para entender melhor como a fun\u00e7\u00e3o ARRUMAR pode melhorar a qualidade dos seus dados. Exemplo 1: Limpeza de Dados Importados Imagine que voc\u00ea importou uma lista de nomes para o Excel e eles est\u00e3o cheios de espa\u00e7os extras. A lista est\u00e1 na coluna A: Jo\u00e3o Maria Carlos Para limpar esses dados, voc\u00ea pode usar a fun\u00e7\u00e3o ARRUMAR nas c\u00e9lulas da coluna B: =ARRUMAR(A1) Ao arrastar a f\u00f3rmula para baixo, a coluna B ser\u00e1 preenchida com os nomes corrigidos, sem espa\u00e7os extras: Jo\u00e3o Maria Carlos Exemplo 2: Combina\u00e7\u00e3o com Outras Fun\u00e7\u00f5es A fun\u00e7\u00e3o ARRUMAR pode ser combinada com outras fun\u00e7\u00f5es para aumentar ainda mais a sua utilidade. Por exemplo, se voc\u00ea quiser concatenar (juntar) duas c\u00e9lulas, mas garantir que n\u00e3o haja espa\u00e7os extras, voc\u00ea pode fazer o seguinte: =CONCATENAR(ARRUMAR(A1), ARRUMAR(B1)) Isso garante que o texto concatenado esteja livre de espa\u00e7os indesejados. Conclus\u00e3o A fun\u00e7\u00e3o ARRUMAR \u00e9 uma ferramenta poderosa no arsenal do Excel, especialmente quando se lida com dados importados ou mal formatados. Ao entender e aplicar esta fun\u00e7\u00e3o, voc\u00ea pode garantir que seus dados estejam sempre limpos e uniformes, facilitando a an\u00e1lise e apresenta\u00e7\u00e3o dos mesmos. All Posts Blog Certificados Diversos Excel FPw Membros Not\u00edcias Planilhas SQL Tecnologia WordPress Assinante | Meus Arquivos Leia mais Tecnologia | Como Bloquear Atualiza\u00e7\u00f5es do Windows em Definitivo Leia mais Tecnologia | Como Transmitir Ao Vivo No OBS Para Facebook: Um Guia Completo Leia mais Cursos Promo\u00e7\u00e3o R$ 500 00 \/Ano Excel para todos SQL do B\u00e1sico ao Avan\u00e7ado FPw INtermedi\u00e1rio Acessar useo Cupom VALE50 e tenha 50% de desconto! Sale Marco Chinarelli Writer &amp; Blogger<\/p>\n","protected":false},"author":2000,"featured_media":1301,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[49,29,48,77,55,56,5,6,47,74,75],"class_list":["post-1300","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-aprenda-como-usar-no-excel-avancado","tag-excel","tag-formula-se-com-procv","tag-funcao-arrumar-com-alguns-truques","tag-funcoes-basicas-do-excel","tag-funcoes-basicas-operadores","tag-menu-dados-completo","tag-saiba-tudo-da-parte-de-dados","tag-software-de-planilha-online-gratuito-excel-microsoft-365","tag-tudo-sobre-formatacao-de-celulas","tag-tudo-sobre-lista-suspensa-no-excel"],"jetpack_sharing_enabled":true,"amp_enabled":false,"jetpack_featured_media_url":"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/07\/funcao-arrumar.jpg","_links":{"self":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/1300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/users\/2000"}],"replies":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/comments?post=1300"}],"version-history":[{"count":0,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/1300\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media\/1301"}],"wp:attachment":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media?parent=1300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/categories?post=1300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/tags?post=1300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}