{"id":13855,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/caracter\/"},"modified":"2021-02-26T08:43:17","modified_gmt":"2021-02-26T08:43:17","slug":"char","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/char\/","title":{"rendered":"CARACTER"},"content":{"rendered":"

Descripci\u00f3n General de la Funci\u00f3n CARACTER<\/h2>\n

La funci\u00f3n CARACTER en Microsoft Excel y Google Sheets se utiliza para devolver un car\u00e1cter basado en su n\u00famero de c\u00f3digo correspondiente en la tabla ASCII (American Standard Code for Information Interchange). Este n\u00famero debe ser un valor entero entre 1 y 255.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n es la siguiente:<\/p>\n

CARACTER(n\u00famero)<\/code><\/pre>\n
Donde n\u00famero<\/code> representa el c\u00f3digo ASCII del car\u00e1cter deseado. A continuaci\u00f3n, se muestran algunos ejemplos:<\/p>\n
    \n
  • CARACTER(65)<\/code> devuelve A<\/code>.<\/li>\n
  • CARACTER(97)<\/code> devuelve a<\/code>.<\/li>\n
  • CARACTER(49)<\/code> devuelve 1<\/code>.<\/li>\n<\/ul>\n
    Aplicaciones Pr\u00e1cticas de la Funci\u00f3n<\/h2>\n
    Creaci\u00f3n de Series Alfab\u00e9ticas<\/h3>\n
    Un uso frecuente de la funci\u00f3n CARACTER es generar series alfab\u00e9ticas de forma din\u00e1mica en una hoja de c\u00e1lculo. Esto es \u00fatil para etiquetar listas autom\u00e1ticamente o para crear plantillas que se ajustan de acuerdo al contenido.<\/p>\n
    Ejemplo de c\u00f3mo crear una serie con las primeras 5 letras del alfabeto:<\/p>\n
    | A1 | =CARACTER(65) | | A2 | =CARACTER(65+1) | | A3 | =CARACTER(65+2) | | A4 | =CARACTER(65+3) | | A5 | =CARACTER(65+4) |<\/code><\/pre>\n
    El resultado ser\u00eda:<\/p>\n
      \n
    • En A1: A<\/li>\n
    • En A2: B<\/li>\n
    • En A3: C<\/li>\n
    • En A4: D<\/li>\n
    • En A5: E<\/li>\n<\/ul>\n
      Conversi\u00f3n de C\u00f3digos ASCII a Texto<\/h3>\n
      Otra aplicaci\u00f3n interesante de la funci\u00f3n CARACTER es la conversi\u00f3n de valores ASCII a texto, lo cual es esencial cuando se trabaja con datos que se presentan en formato de c\u00f3digos num\u00e9ricos y necesitan ser convertidos a un formato legible.<\/p>\n
      Supongamos que tienes una lista de c\u00f3digos ASCII en una columna y quieres convertir estos c\u00f3digos a sus caracteres correspondientes:<\/p>\n
      | B1 | 72 | | B2 | 101 | | B3 | 108 | | B4 | 108 | | B5 | 111 |<\/code><\/pre>\n
      Puedes utilizar la siguiente f\u00f3rmula para realizar la conversi\u00f3n:<\/p>\n
      | C1 | =CARACTER(B1) | | C2 | =CARACTER(B2) | | C3 | =CARACTER(B3) | | C4 | =CARACTER(B4) | | C5 | =CARACTER(B5) |<\/code><\/pre>\n
      El resultado en la columna C ser\u00e1:<\/p>\n
        \n
      • En C1: H<\/li>\n
      • En C2: e<\/li>\n
      • En C3: l<\/li>\n
      • En C4: l<\/li>\n
      • En C5: o<\/li>\n<\/ul>\n
        Estos son solo algunos ejemplos de lo que puedes lograr con la funci\u00f3n CARACTER, una herramienta muy \u00fatil en diversas situaciones, especialmente cuando se manejan datos que requieren transcripci\u00f3n de c\u00f3digos a caracteres legibles.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Devuelve el car\u00e1cter especificado por el n\u00famero de c\u00f3digo<\/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-13855","post","type-post","status-publish","format-standard","hentry","category-texto-2"],"acf":[],"yoast_head":"\nFunci\u00f3n CHAR (CARACTER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n CHAR (CARACTER) 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\/char\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n CHAR (CARACTER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n CHAR (CARACTER) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/char\/\" \/>\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:43:17+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 CHAR (CARACTER) 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\/char\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/char\/\",\"name\":\"Funci\u00f3n CHAR (CARACTER) 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:43:17+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n CHAR (CARACTER) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/char\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/char\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/char\/#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\":\"CARACTER\"}]},{\"@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 CHAR (CARACTER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n CHAR (CARACTER) 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\/char\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n CHAR (CARACTER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n CHAR (CARACTER) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/char\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:43:17+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n CHAR (CARACTER) 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\/char\/","url":"https:\/\/functiontranslator.com\/es\/char\/","name":"Funci\u00f3n CHAR (CARACTER) 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:43:17+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n CHAR (CARACTER) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/char\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/char\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/char\/#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":"CARACTER"}]},{"@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\/13855","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=13855"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13855\/revisions"}],"predecessor-version":[{"id":29918,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13855\/revisions\/29918"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13855"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}