{"id":6730,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/nompropre\/"},"modified":"2021-02-26T08:12:22","modified_gmt":"2021-02-26T08:12:22","slug":"proper","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/proper\/","title":{"rendered":"NOMPROPRE"},"content":{"rendered":"

Syntaxe et description g\u00e9n\u00e9rale<\/h2>\n

La fonction PROPER<\/strong> (ou NOMPROPRE<\/strong> en fran\u00e7ais) dans Microsoft Excel et Google Sheets est con\u00e7ue pour transformer la premi\u00e8re lettre de chaque mot d’une cha\u00eene de texte en majuscule, tout en convertissant toutes les autres lettres en minuscules. Cette fonction s’av\u00e8re particuli\u00e8rement utile pour standardiser la pr\u00e9sentation du texte dans les donn\u00e9es.<\/p>\n

La syntaxe de la fonction est la suivante :<\/p>\n

=PROPER(texte)<\/code><\/pre>\n
O\u00f9 \u00ab\u00a0texte\u00a0\u00bb repr\u00e9sente le texte \u00e0 convertir. Celui-ci peut \u00eatre une r\u00e9f\u00e9rence \u00e0 une cellule contenant le texte ou le texte directement entre guillemets.<\/p>\n
Exemples d’utilisation<\/h2>\n
Consid\u00e9rez la liste suivante de noms dans une colonne, dont la capitalisation est incorrecte :<\/p>\n
    \n
  • jean DUPONT<\/li>\n
  • MARIE d’ALEMBERT<\/li>\n
  • l\u00e9o martinELLI<\/li>\n<\/ul>\n
    Vous pouvez appliquer la fonction PROPER pour corriger la capitalisation de chaque nom.<\/p>\n
    =PROPER(A1) =PROPER(A2) =PROPER(A3)<\/code><\/pre>\n
    Une fois la fonction appliqu\u00e9e, les noms seront corrig\u00e9s comme suit :<\/p>\n
      \n
    • Jean Dupont<\/li>\n
    • Marie D’Alembert<\/li>\n
    • L\u00e9o Martinelli<\/li>\n<\/ul>\n
      Applications pratiques<\/h2>\n
      Normalisation des donn\u00e9es de formulaire<\/h2>\n
      Imaginez que vous traitiez des donn\u00e9es issues d’un formulaire en ligne o\u00f9 les utilisateurs n’ont pas utilis\u00e9 la capitalisation appropri\u00e9e pour leurs noms. Voici comment vous pourriez utiliser la fonction pour standardiser les noms :<\/p>\n\n\n\n\n\n
      Noms entr\u00e9s<\/th>\nNoms corrig\u00e9s<\/th>\n<\/tr>\n
      anne LEROY<\/td>\n=PROPER(A2)<\/td>\n<\/tr>\n
      PIERRE lebrun<\/td>\n=PROPER(A3)<\/td>\n<\/tr>\n
      \u00c9LODIE durand<\/td>\n=PROPER(A4)<\/td>\n<\/tr>\n<\/table>\n
      Les formules dans la colonne \u00ab\u00a0Noms corrig\u00e9s\u00a0\u00bb ajusteront les noms en \u00ab\u00a0Anne Leroy\u00a0\u00bb, \u00ab\u00a0Pierre Lebrun\u00a0\u00bb et \u00ab\u00a0\u00c9lodie Durand\u00a0\u00bb, respectivement.<\/p>\n
      Cr\u00e9ation d’envois de mails personnalis\u00e9s<\/h2>\n
      Lors de pr\u00e9parations d’envois de courriels en masse, o\u00f9 les noms des destinataires doivent \u00eatre pr\u00e9cis\u00e9ment format\u00e9s, l’utilisation de cette fonction est tr\u00e8s avantageuse. Voici un exemple simple :<\/p>\n
      Madame, Monsieur =PROPER(B2)<\/code>,<\/pre>\n
      Si B2 contient \u00ab\u00a0michelle O’CONNOR\u00a0\u00bb, la fonction PROPER la transformera en \u00ab\u00a0Michelle O’Connor\u00a0\u00bb, ce qui permet de personnaliser davantage le courriel.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Met en Majuscules la preMi\u00e8re lettre de chaque Mot dans une cha\u00eene textuelle<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[314],"tags":[],"class_list":["post-6730","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction PROPER (NOMPROPRE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction PROPER (NOMPROPRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\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\/fr\/proper\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction PROPER (NOMPROPRE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction PROPER (NOMPROPRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/proper\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:12:22+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction PROPER (NOMPROPRE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/proper\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/proper\/\",\"name\":\"Fonction PROPER (NOMPROPRE) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:12:22+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction PROPER (NOMPROPRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/proper\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/proper\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/proper\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Texte\",\"item\":\"https:\/\/functiontranslator.com\/fr\/texte\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"NOMPROPRE\"}]},{\"@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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction PROPER (NOMPROPRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction PROPER (NOMPROPRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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\/fr\/proper\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction PROPER (NOMPROPRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction PROPER (NOMPROPRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/proper\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:12:22+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction PROPER (NOMPROPRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/proper\/","url":"https:\/\/functiontranslator.com\/fr\/proper\/","name":"Fonction PROPER (NOMPROPRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:12:22+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction PROPER (NOMPROPRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/proper\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/proper\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/proper\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Texte","item":"https:\/\/functiontranslator.com\/fr\/texte\/"},{"@type":"ListItem","position":3,"name":"NOMPROPRE"}]},{"@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":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6730","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6730"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6730\/revisions"}],"predecessor-version":[{"id":29741,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6730\/revisions\/29741"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6730"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6730"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}