{"id":234,"date":"2023-11-10T10:28:08","date_gmt":"2023-11-10T10:28:08","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/"},"modified":"2023-12-25T10:24:34","modified_gmt":"2023-12-25T10:24:34","slug":"contar-caracteres-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/","title":{"rendered":"\u00bfc\u00f3mo contar caracteres en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3937015573\"><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 este tutorial, aprenderemos a escribir diferentes f\u00f3rmulas en Excel para contar la cantidad de caracteres en una celda o rango de celdas.<\/p>\n<h2 class=\"wp-block-heading\"> Contar caracteres en una sola celda<\/h2>\n<p> Para contar los caracteres de una celda, debes ingresar la funci\u00f3n LEN en la celda en la que deseas obtener el n\u00famero. Despu\u00e9s de eso, consulte la celda (A1). Al final, presione Enter para obtener el recuento. Si tiene varias celdas, tambi\u00e9n puede aplicar la misma f\u00f3rmula a esas celdas.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=LEN(B1)<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Contar caracteres sin espacios<\/h2>\n<p> Si tiene uno o varios espacios en una celda, en este caso puede usar la siguiente f\u00f3rmula donde hemos usado una combinaci\u00f3n de LEN y SUSTITUTO. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79309\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.png\" sizes=\"auto, \" srcset=\"\" alt=\"contar-caracteres-sin-espacios\" width=\"525\" height=\"269\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=LEN(SUBSTITUTE(A1,\" \",\"\"))<\/code><\/pre>\n<p> En esta f\u00f3rmula, usamos SUSTITUIR para reemplazar el espacio que tienes entre \u00abHola\u00bb y \u00ab\u00a1Mundo!\u00bb. \u00bb con un valor vac\u00edo.<\/p>\n<h2 class=\"wp-block-heading\"> Contar caracteres en un rango<\/h2>\n<p> Si tiene un rango de celdas y desea contar caracteres en ese rango completo, puede usar una combinaci\u00f3n de SUMPRODUCT y LEN.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(LEN(A1:A3))<\/code><\/pre>\n<p> Cuando usa SUMPRODUCT, puede tomar una tabla en una sola celda. De esta manera toma el valor de todas las celdas (3) del rango. Y entre SUMPRODUCT, LEN obtiene la cantidad de caracteres.<\/p>\n<p> Si tiene una celda o varias celdas donde tiene un espacio en el valor y no desea contar ese espacio al contar caracteres. Debes crear una combinaci\u00f3n de SUMPRODUCT, LEN y SUBSTITUTE.<\/p>\n<p> En el ejemplo anterior, tenemos el n\u00famero 36 cuando incluye el espacio y obtiene la cantidad de caracteres. Pero cuando usamos la f\u00f3rmula (SUMPRODUCTO, SUSTITUTO y LEN).<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(LEN(SUBSTITUTE(A1:A3,\" \",\"\")))<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Cuente un car\u00e1cter espec\u00edfico de una celda o rango<\/h2>\n<p> Supongamos que desea obtener el recuento de un car\u00e1cter espec\u00edfico de una celda; puede hacerlo combinando LEN y SUSTITUTO. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79312\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-compter-un-caractere-specifique.png\" sizes=\"auto, \" srcset=\"\" alt=\"contar un car\u00e1cter espec\u00edfico\" width=\"593\" height=\"302\"><\/figure>\n<\/div>\n<p> En el ejemplo anterior, usamos la f\u00f3rmula para contar el asterisco (*) de la celda. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=LEN(A1)-LEN(SUBSTITUTE(A1,\"*\",\"\"))<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79313\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-comprendre-len-et-remplacer-la-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"comprender-len-y-sustituir-la-funci\u00f3n\" width=\"549\" height=\"118\"><\/figure>\n<\/div>\n<p> Esta funci\u00f3n funciona en dos partes:<\/p>\n<ul>\n<li> En la primera parte, tienes la funci\u00f3n LEN que obtiene el n\u00famero total de caracteres en la celda.<\/li>\n<li> En la segunda parte tienes SUSTITUTO que reemplaza el (*) sin valor. Despu\u00e9s de eso, LEN devuelve el n\u00famero de caracteres sin asterisco.<\/li>\n<\/ul>\n<p> Al final tienes dos cuentas, una con (*) y otra sin (*). Y cuando restas los dos, obtienes el n\u00famero de (*) en el resultado.<\/p>\n<p> Y de manera similar, si desea contar un car\u00e1cter espec\u00edfico de un rango de celdas y necesita ajustar la f\u00f3rmula anterior en la funci\u00f3n SUMAPRODUCTO y hacer referencia a todo el rango en lugar de a una sola celda. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(LEN(A1:A7)-LEN(SUBSTITUTE(A1:A7,\"*\",\"\")))<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79314\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-sumproduct-et-fonction-len.png\" sizes=\"auto, \" srcset=\"\" alt=\"funci\u00f3n sumaproducto-y-len\" width=\"574\" height=\"402\"><\/figure>\n<\/div>\n<p> Cuando usa SUMPRODUCT, toma todo el rango como una tabla y usa la f\u00f3rmula para todo el rango en lugar de solo una celda. Eso significa:<\/p>\n<p> En la primera parte obtienes el n\u00famero total de caracteres de todo el rango, y en la segunda parte SUSTITUIR, eliminas el (*) y LEN obtiene el n\u00famero. Y despu\u00e9s de eso, al deducir ambos conteos, obtienes el n\u00famero del personaje espec\u00edfico en el resultado. <\/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\/compter-les-caracteres.xlsx\" rel=\"nofollow\">Descargar<\/a><\/p>\n<\/div>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-5b4a0cf9\">\n<div class=\"gb-container gb-container-5b4a0cf9\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/generar-grupos-aleatorios\/\">Generar grupos aleatorios<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/comparar-canales-2\/\">Comparar dos cadenas (texto)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/obtener-dominio\/\">Obtener dominio a partir de la identificaci\u00f3n del correo electr\u00f3nico<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/extraer-solo-numeros\/\">Extraer solo n\u00fameros de un texto (cadena)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/texto-despues-antes\/\">Extraer texto antes y despu\u00e9s de un car\u00e1cter en Excel<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En este tutorial, aprenderemos a escribir diferentes f\u00f3rmulas en Excel para contar la cantidad de caracteres en una celda o rango de celdas. Contar caracteres en una sola celda Para contar los caracteres de una celda, debes ingresar la funci\u00f3n LEN en la celda en la que deseas obtener el n\u00famero. Despu\u00e9s de eso, consulte [&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-234","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 contar caracteres 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\/contar-caracteres-2\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo contar caracteres en excel?\" \/>\n<meta property=\"og:description\" content=\"En este tutorial, aprenderemos a escribir diferentes f\u00f3rmulas en Excel para contar la cantidad de caracteres en una celda o rango de celdas. Contar caracteres en una sola celda Para contar los caracteres de una celda, debes ingresar la funci\u00f3n LEN en la celda en la que deseas obtener el n\u00famero. Despu\u00e9s de eso, consulte [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:24:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.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=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/\",\"name\":\"\u00bfc\u00f3mo contar caracteres en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.png\",\"datePublished\":\"2023-11-10T10:28:08+00:00\",\"dateModified\":\"2023-12-25T10:24:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo contar caracteres 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 contar caracteres 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\/contar-caracteres-2\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo contar caracteres en excel?","og_description":"En este tutorial, aprenderemos a escribir diferentes f\u00f3rmulas en Excel para contar la cantidad de caracteres en una celda o rango de celdas. Contar caracteres en una sola celda Para contar los caracteres de una celda, debes ingresar la funci\u00f3n LEN en la celda en la que deseas obtener el n\u00famero. Despu\u00e9s de eso, consulte [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:24:34+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/","url":"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/","name":"\u00bfc\u00f3mo contar caracteres en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.png","datePublished":"2023-11-10T10:28:08+00:00","dateModified":"2023-12-25T10:24:34+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-chiffres-sans-espaces.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/contar-caracteres-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo contar caracteres 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\/234","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=234"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/234\/revisions"}],"predecessor-version":[{"id":937,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/234\/revisions\/937"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}