{"id":14066,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/funciones-largo-largob\/"},"modified":"2021-02-26T08:53:10","modified_gmt":"2021-02-26T08:53:10","slug":"len-lenbs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/len-lenbs\/","title":{"rendered":"LARGO, LARGOB"},"content":{"rendered":"

En el \u00e1mbito de las hojas de c\u00e1lculo, tanto Microsoft Excel como Google Sheets ofrecen una amplia gama de herramientas dise\u00f1adas para simplificar la manipulaci\u00f3n y el an\u00e1lisis de datos. Entre estas herramientas destacan las funciones LARGO<\/strong> y LARGOB<\/strong>, fundamentales para trabajar con datos de texto al permitirnos determinar la longitud de una cadena de caracteres.<\/p>\n

Sintaxis y ejemplos b\u00e1sicos<\/h2>\n

Sintaxis de LARGO:<\/strong><\/p>\n

=LARGO(texto)<\/code><\/pre>\n
Descripci\u00f3n:<\/strong> La funci\u00f3n LARGO<\/code> calcula el n\u00famero de caracteres presentes en un texto.<\/p>\n
Ejemplo:<\/strong><\/p>\n
=LARGO(\"Excel\")<\/code><\/pre>\n
Resultado: 5<\/p>\n
Sintaxis de LARGOB:<\/strong><\/p>\n
=LARGOB(texto)<\/code><\/pre>\n
Descripci\u00f3n:<\/strong> Funciona de manera similar a LARGO<\/code>, pero LARGOB<\/code> cuenta los bytes de los caracteres en lugar de los caracteres mismos. Esto es particularmente relevante para caracteres de doble byte, como algunos caracteres japoneses, donde cada car\u00e1cter se cuenta como dos bytes.<\/p>\n
Ejemplo:<\/strong><\/p>\n
=LARGOB(\"\u30c7\u30fc\u30bf\")<\/code><\/pre>\n
Resultado: 4<\/p>\n
Primer escenario pr\u00e1ctico<\/h2>\n
Contexto:<\/strong> Supongamos que tenemos una lista con nombres completos y necesitamos determinar cu\u00e1ntos caracteres incluye cada uno para dise\u00f1ar identificaciones donde el espacio es limitado.<\/p>\n
Datos:<\/strong><\/p>\n
    \n
  • Juan Perez<\/li>\n
  • Ana Mar\u00eda G\u00f3mez<\/li>\n
  • Carlos Mor\u00e1n<\/li>\n<\/ul>\n\n\n\n\n\n
    Nombre Completo<\/th>\nF\u00f3rmula<\/th>\nResultado<\/th>\n<\/tr>\n
    Juan Perez<\/td>\n=LARGO(A2)<\/code><\/td>\n10<\/td>\n<\/tr>\n
    Ana Mar\u00eda G\u00f3mez<\/td>\n=LARGO(A3)<\/code><\/td>\n14<\/td>\n<\/tr>\n
    Carlos Mor\u00e1n<\/td>\n=LARGO(A4)<\/code><\/td>\n12<\/td>\n<\/tr>\n<\/table>\n
    Con estos datos podemos ajustar adecuadamente el dise\u00f1o de las identificaciones para que los nombres completos se ajusten al espacio disponible.<\/p>\n
    Segundo escenario pr\u00e1ctico<\/h2>\n
    Contexto:<\/strong> Un analista necesita comprobar que los c\u00f3digos de producto en una base de datos mantengan un formato uniforme, debiendo contener exactamente 8 caracteres.<\/p>\n
    Datos:<\/strong><\/p>\n
      \n
    • 12345678 (Correcto)<\/li>\n
    • 87654321 (Correcto)<\/li>\n
    • A12345 (Incorrecto, s\u00f3lo 6 caracteres)<\/li>\n<\/ul>\n\n\n\n\n\n
      C\u00f3digo de Producto<\/th>\nF\u00f3rmula<\/th>\nLongitud<\/th>\nEstado<\/th>\n<\/tr>\n
      12345678<\/td>\n=LARGO(A2)<\/code><\/td>\n8<\/td>\nCorrecto<\/td>\n<\/tr>\n
      87654321<\/td>\n=LARGO(A3)<\/code><\/td>\n8<\/td>\nCorrecto<\/td>\n<\/tr>\n
      A12345<\/td>\n=LARGO(A4)<\/code><\/td>\n6<\/td>\nIncorrecto<\/td>\n<\/tr>\n<\/table>\n
      Este an\u00e1lisis permite identificar r\u00e1pidamente las entradas que no cumplen con el formato requerido y que necesitan correcci\u00f3n para asegurar la coherencia en la base de datos de productos.<\/p>\n
      Las funciones LARGO<\/strong> y LARGOB<\/strong> proveen de herramientas poderosas para cualquier profesional involucrado en la gesti\u00f3n de grandes vol\u00famenes de texto en hojas de c\u00e1lculo, facilitando el an\u00e1lisis y la manipulaci\u00f3n de datos de manera efectiva y precisa.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Devuelve el n\u00famero de caracteres de una cadena de texto<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[539],"tags":[],"class_list":["post-14066","post","type-post","status-publish","format-standard","hentry","category-texto-2"],"acf":[],"yoast_head":"\nFunci\u00f3n LEN, LENBs (LARGO, LARGOB) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n LEN, LENBs (LARGO, LARGOB) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos 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\/es\/len-lenbs\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n LEN, LENBs (LARGO, LARGOB) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n LEN, LENBs (LARGO, LARGOB) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/len-lenbs\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:53:10+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n LEN, LENBs (LARGO, LARGOB) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\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\/es\/len-lenbs\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/len-lenbs\/\",\"name\":\"Funci\u00f3n LEN, LENBs (LARGO, LARGOB) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:53:10+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n LEN, LENBs (LARGO, LARGOB) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/len-lenbs\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/len-lenbs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/len-lenbs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Texto\",\"item\":\"https:\/\/functiontranslator.com\/es\/texto-2\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"LARGO, LARGOB\"}]},{\"@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\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n LEN, LENBs (LARGO, LARGOB) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n LEN, LENBs (LARGO, LARGOB) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos 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\/es\/len-lenbs\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n LEN, LENBs (LARGO, LARGOB) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n LEN, LENBs (LARGO, LARGOB) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/len-lenbs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:53:10+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n LEN, LENBs (LARGO, LARGOB) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/len-lenbs\/","url":"https:\/\/functiontranslator.com\/es\/len-lenbs\/","name":"Funci\u00f3n LEN, LENBs (LARGO, LARGOB) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:53:10+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n LEN, LENBs (LARGO, LARGOB) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/len-lenbs\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/len-lenbs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/len-lenbs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Texto","item":"https:\/\/functiontranslator.com\/es\/texto-2\/"},{"@type":"ListItem","position":3,"name":"LARGO, LARGOB"}]},{"@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":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14066","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=14066"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14066\/revisions"}],"predecessor-version":[{"id":30159,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14066\/revisions\/30159"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}