{"id":14155,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/nompropio\/"},"modified":"2021-02-26T08:56:25","modified_gmt":"2021-02-26T08:56:25","slug":"proper","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/proper\/","title":{"rendered":"NOMPROPIO"},"content":{"rendered":"

En Microsoft Excel y Google Sheets, la funci\u00f3n NOMPROPIO, conocida en ingl\u00e9s como PROPER, es esencial para formatear texto. Esta funci\u00f3n capitaliza la primera letra de cada palabra, mientras que el resto de letras se convierten en min\u00fasculas. Resulta muy \u00fatil para la normalizaci\u00f3n de datos, especialmente cuando se manejan nombres propios, direcciones y otros elementos que necesitan un formato tipogr\u00e1fico espec\u00edfico.<\/p>\n

Descripci\u00f3n y Sintaxis<\/h2>\n

La sintaxis de la funci\u00f3n NOMPROPIO es id\u00e9ntica en Excel y Google Sheets:<\/p>\n

=NOMPROPIO(texto)<\/code><\/pre>\n
    \n
  • texto<\/strong>: Es la cadena de texto que deseas modificar. Puedes insertar directamente el texto entre comillas o referenciar una celda que contenga el texto.<\/li>\n<\/ul>\n
    Por ejemplo:<\/p>\n
    =NOMPROPIO(\"juan perez\")<\/code><\/pre>\n
    Este ejemplo convertir\u00e1 el texto a \u00abJuan Perez\u00bb, aplicando may\u00fasculas al inicio de cada palabra.<\/p>\n
    Ejemplos pr\u00e1cticos<\/h2>\n
    A continuaci\u00f3n, se presentan dos escenarios en los que la funci\u00f3n NOMPROPIO resulta particularmente beneficiosa:<\/p>\n
    Caso 1: Limpieza de Datos de Entrada<\/h2>\n
    Imagina que dispones de una lista de nombres completos en una columna de una hoja de c\u00e1lculo, pero todos est\u00e1n escritos en min\u00fasculas. Si deseas estandarizar el formato de estos nombres, puedes hacerlo de la siguiente manera:<\/p>\n\n\n\n\n
    Celda<\/th>\nDatos Originales<\/th>\nDatos Formateados<\/th>\n<\/tr>\n
    A1<\/td>\nmaria fernandez<\/td>\n=NOMPROPIO(A1)<\/td>\n<\/tr>\n
    A2<\/td>\nluis g\u00f3mez<\/td>\n=NOMPROPIO(A2)<\/td>\n<\/tr>\n<\/table>\n
    Al utilizar la funci\u00f3n, las celdas transformadas mostrar\u00e1n \u00abMaria Fernandez\u00bb y \u00abLuis G\u00f3mez\u00bb, mejorando la consistencia y legibilidad de los datos.<\/p>\n
    Caso 2: Formateo de T\u00edtulos en un Documento<\/h2>\n
    Si est\u00e1s preparando un informe o cualquier otro documento que incluya t\u00edtulos extra\u00eddos de una hoja de c\u00e1lculo, es deseable que cada palabra del t\u00edtulo comience con may\u00fascula. Por ejemplo, si el texto \u00abinforme anual de resultados\u00bb se encuentra en la celda B1, puedes formatearlo como sigue:<\/p>\n
    =NOMPROPIO(B1)<\/code><\/pre>\n
    Esta acci\u00f3n convertir\u00e1 el texto a \u00abInforme Anual De Resultados\u00bb, adecu\u00e1ndolo para un documento formal.<\/p>\n
    Estos ejemplos destacan c\u00f3mo la funci\u00f3n NOMPROPIO puede ser extremadamente \u00fatil en diversas situaciones pr\u00e1cticas, tanto para la gesti\u00f3n como para la presentaci\u00f3n de datos en Excel y Google Sheets, permitiendo presentar la informaci\u00f3n de manera m\u00e1s profesional y clara.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Pone en may\u00fascula la primera letra de cada palabra de un valor 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-14155","post","type-post","status-publish","format-standard","hentry","category-texto-2"],"acf":[],"yoast_head":"\nFunci\u00f3n PROPER (NOMPROPIO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PROPER (NOMPROPIO) 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\/proper\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n PROPER (NOMPROPIO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PROPER (NOMPROPIO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/proper\/\" \/>\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:56:25+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 PROPER (NOMPROPIO) 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\/proper\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/proper\/\",\"name\":\"Funci\u00f3n PROPER (NOMPROPIO) 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:56:25+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n PROPER (NOMPROPIO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/proper\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/proper\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/proper\/#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\":\"NOMPROPIO\"}]},{\"@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 PROPER (NOMPROPIO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n PROPER (NOMPROPIO) 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\/proper\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n PROPER (NOMPROPIO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n PROPER (NOMPROPIO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/proper\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:56:25+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n PROPER (NOMPROPIO) 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\/proper\/","url":"https:\/\/functiontranslator.com\/es\/proper\/","name":"Funci\u00f3n PROPER (NOMPROPIO) 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:56:25+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n PROPER (NOMPROPIO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/proper\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/proper\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/proper\/#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":"NOMPROPIO"}]},{"@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\/14155","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=14155"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14155\/revisions"}],"predecessor-version":[{"id":30246,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14155\/revisions\/30246"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}