{"id":279,"date":"2023-11-07T02:05:28","date_gmt":"2023-11-07T02:05:28","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/"},"modified":"2023-12-25T10:24:52","modified_gmt":"2023-12-25T10:24:52","slug":"eliminar-caracteres-no-deseados","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/","title":{"rendered":"\u00bfc\u00f3mo eliminar caracteres no deseados en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1866927444\"><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>En Excel, cuando trabaja con datos, es posible que tenga que lidiar con caracteres que no desea. En este caso, puedes escribir una f\u00f3rmula usando SUSTITUIR que puede eliminar estos caracteres no deseados. Y en este tutorial, aprenderemos c\u00f3mo escribir esta f\u00f3rmula.<\/p>\n<h2 class=\"wp-block-heading\"> F\u00f3rmula para eliminar caracteres no deseados<\/h2>\n<p> Siga estos pasos para escribir esta f\u00f3rmula:<\/p>\n<ol type=\"1\">\n<li> Primero, en una celda, ingrese la funci\u00f3n REEMPLAZAR.<\/li>\n<li> A continuaci\u00f3n, consulte la celda donde se encuentra el texto original.<\/li>\n<li> Despu\u00e9s de eso, ingrese el car\u00e1cter que desea eliminar (use comillas dobles).<\/li>\n<li> Ahora ingrese un car\u00e1cter en blanco usando comillas dobles.<\/li>\n<li> Al final, presione Enter para obtener el resultado. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13492\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png\" alt=\"eliminar car\u00e1cter no deseado\" width=\"500\" height=\"183\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png 500w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable-300x110.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBSTITUTE(A1,\"@\",\" \")<\/code><\/pre>\n<p> Esta f\u00f3rmula elimina el car\u00e1cter \u00ab@\u00bb del valor en la celda A1 y lo reemplaza sin ning\u00fan car\u00e1cter. En lugar de reemplazarlo por nada, tambi\u00e9n puedes usar espacios en blanco.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBSTITUTE(A1,\"@\",\"\")<\/code><\/pre>\n<p> Usar la funci\u00f3n SUSTITUIR es la forma m\u00e1s r\u00e1pida de eliminar caracteres no deseados de una cadena. Y si desea eliminar dos o m\u00e1s caracteres de una sola celda, debe usar la funci\u00f3n REEMPLAZAR dos veces. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13490\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-plusieurs-caracteres-indesirable.png\" alt=\"eliminar-m\u00faltiples-caracteres-basura\" width=\"500\" height=\"220\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-plusieurs-caracteres-indesirable.png 500w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-plusieurs-caracteres-indesirable-300x132.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\"><\/figure>\n<\/div>\n<p> En el ejemplo anterior tienes tres caracteres diferentes que no queremos tener en la cadena de texto. Entonces ahora necesitas usar un SUSTITUTO anidado para eliminar estos caracteres.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,\"@\",\"\"),\"!\",\"\"),\"-\",\"\")<\/code><\/pre>\n<p> Tienes tres funciones SUSTITUIR; la f\u00f3rmula elimina un car\u00e1cter no deseado con cada funci\u00f3n. <\/p>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/caracteres-indesirables.xlsx\" rel=\"nofollow\">Descargar<\/a><\/p>\n<\/div>\n<div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/vba\/\">\u00bfQu\u00e9 es VBA?<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> Eliminar el primer car\u00e1cter de una celda en Excel<\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/eliminar-espacios-adicionales\/\">Eliminar espacios adicionales en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/obtener-la-primera-ultima-palabra\/\">Separar nombres en Excel \u2013 (Nombre y apellido)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/extraer-la-ultima-palabra-2\/\">Extraer la \u00faltima palabra de una celda.<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/eliminar-salto-de-linea-2\/\">Eliminar salto de l\u00ednea de una celda<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, cuando trabaja con datos, es posible que tenga que lidiar con caracteres que no desea. En este caso, puedes escribir una f\u00f3rmula usando SUSTITUIR que puede eliminar estos caracteres no deseados. Y en este tutorial, aprenderemos c\u00f3mo escribir esta f\u00f3rmula. F\u00f3rmula para eliminar caracteres no deseados Siga estos pasos para escribir esta f\u00f3rmula: [&hellip;]<\/p>\n","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-279","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>\u00bfc\u00f3mo eliminar caracteres no deseados en excel?<\/title>\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\/es\/eliminar-caracteres-no-deseados\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo eliminar caracteres no deseados en excel?\" \/>\n<meta property=\"og:description\" content=\"En Excel, cuando trabaja con datos, es posible que tenga que lidiar con caracteres que no desea. En este caso, puedes escribir una f\u00f3rmula usando SUSTITUIR que puede eliminar estos caracteres no deseados. Y en este tutorial, aprenderemos c\u00f3mo escribir esta f\u00f3rmula. F\u00f3rmula para eliminar caracteres no deseados Siga estos pasos para escribir esta f\u00f3rmula: [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:24:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/\",\"name\":\"\u00bfc\u00f3mo eliminar caracteres no deseados en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png\",\"datePublished\":\"2023-11-07T02:05:28+00:00\",\"dateModified\":\"2023-12-25T10:24:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo eliminar caracteres no deseados en excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo eliminar caracteres no deseados en 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\/es\/eliminar-caracteres-no-deseados\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo eliminar caracteres no deseados en excel?","og_description":"En Excel, cuando trabaja con datos, es posible que tenga que lidiar con caracteres que no desea. En este caso, puedes escribir una f\u00f3rmula usando SUSTITUIR que puede eliminar estos caracteres no deseados. Y en este tutorial, aprenderemos c\u00f3mo escribir esta f\u00f3rmula. F\u00f3rmula para eliminar caracteres no deseados Siga estos pasos para escribir esta f\u00f3rmula: [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:24:52+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/","url":"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/","name":"\u00bfc\u00f3mo eliminar caracteres no deseados en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png","datePublished":"2023-11-07T02:05:28+00:00","dateModified":"2023-12-25T10:24:52+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/eliminar-caracteres-no-deseados\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo eliminar caracteres no deseados en excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=279"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/279\/revisions"}],"predecessor-version":[{"id":968,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/279\/revisions\/968"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}