{"id":6653,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/minuscule\/"},"modified":"2021-02-26T08:10:02","modified_gmt":"2021-02-26T08:10:02","slug":"lower","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/lower\/","title":{"rendered":"MINUSCULE"},"content":{"rendered":"

Syntaxe et description de la fonction<\/h2>\n

La fonction MINUSCULE dans MS Excel et Google Sheets permet de convertir tous les caract\u00e8res d’une cha\u00eene de texte en minuscules. Cette fonction est particuli\u00e8rement utile pour standardiser les donn\u00e9es textuelles avant d’effectuer des comparaisons, des recherches ou des analyses.<\/p>\n

Syntaxe dans Excel :<\/strong><\/p>\n

=MINUSCULE(texte)<\/code><\/pre>\n
Syntaxe dans Google Sheets :<\/strong><\/p>\n
=MINUSCULE(texte)<\/code><\/pre>\n
O\u00f9 texte<\/em> repr\u00e9sente la cha\u00eene de caract\u00e8res \u00e0 convertir en minuscules.<\/p>\n
Exemple d’utilisation :<\/strong><\/p>\n
    \n
  • =MINUSCULE(\"Bonjour LE MONDE\")<\/code> renvoie bonjour le monde<\/code>.<\/li>\n<\/ul>\n
    Exemples pratiques d’utilisation<\/h2>\n
    Voici quelques situations concr\u00e8tes o\u00f9 utiliser la fonction MINUSCULE peut \u00eatre b\u00e9n\u00e9fique.<\/p>\n
    Cas pratique 1 : Nettoyage de donn\u00e9es<\/h2>\n
    Imaginez que vous disposez d’une liste de noms d’utilisateurs collect\u00e9s via divers formulaires, o\u00f9 les formats d’entr\u00e9e varient. Certains noms sont enti\u00e8rement en majuscules, d’autres en minuscules ou en format mixte. Utiliser la fonction MINUSCULE vous aide \u00e0 harmoniser ces donn\u00e9es.<\/p>\n
    Donn\u00e9es de d\u00e9part :<\/strong><\/p>\n\n\n\n\n\n
    Noms<\/th>\n<\/tr>\n
    Jean DUPONT<\/td>\n<\/tr>\n
    Marie-Claire \u00c9TOILE<\/td>\n<\/tr>\n
    pierre DURAND<\/td>\n<\/tr>\n<\/table>\n
    Formule \u00e0 utiliser :<\/strong><\/p>\n
    =MINUSCULE(A2)<\/code><\/pre>\n
    Appliquez cette formule \u00e0 chaque nom dans une nouvelle colonne pour convertir tous les noms en minuscules.<\/p>\n
    Cas pratique 2 : Comparaison de cha\u00eenes de texte<\/h2>\n
    Lors de la manipulation de bases de donn\u00e9es textuelles, il est fr\u00e9quent que les variations de casse des lettres entra\u00eenent des incoh\u00e9rences lors des comparaisons. Convertir toutes les entr\u00e9es en minuscules garantit des comparaisons pr\u00e9cises et coh\u00e9rentes.<\/p>\n
    Exemple :<\/strong> Supposons que vous vouliez identifier les doublons dans une liste d’emails.<\/p>\n
    Donn\u00e9es de d\u00e9part :<\/strong><\/p>\n\n\n\n\n\n
    Emails<\/th>\n<\/tr>\n
    example@domain.com<\/td>\n<\/tr>\n
    Example@domain.com<\/td>\n<\/tr>\n
    eXaMple@Domain.com<\/td>\n<\/tr>\n<\/table>\n
    Solution :<\/strong><\/p>\n
    =MINUSCULE(A2)<\/code><\/pre>\n
    Appliquez cette formule \u00e0 chaque adresse email et utilisez ensuite une fonction de recherches de doublons pour d\u00e9tecter les entr\u00e9es r\u00e9p\u00e9t\u00e9es, ind\u00e9pendamment de la casse d’origine des caract\u00e8res.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Convertit le texte en minusCules<\/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-6653","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction LOWER (MINUSCULE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction LOWER (MINUSCULE) 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\/lower\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction LOWER (MINUSCULE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction LOWER (MINUSCULE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/lower\/\" \/>\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:10:02+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction LOWER (MINUSCULE) 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\/lower\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/lower\/\",\"name\":\"Fonction LOWER (MINUSCULE) 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:10:02+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction LOWER (MINUSCULE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/lower\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/lower\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/lower\/#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\":\"MINUSCULE\"}]},{\"@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 LOWER (MINUSCULE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction LOWER (MINUSCULE) 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\/lower\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction LOWER (MINUSCULE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction LOWER (MINUSCULE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/lower\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:02+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction LOWER (MINUSCULE) 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\/lower\/","url":"https:\/\/functiontranslator.com\/fr\/lower\/","name":"Fonction LOWER (MINUSCULE) 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:10:02+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction LOWER (MINUSCULE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/lower\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/lower\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/lower\/#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":"MINUSCULE"}]},{"@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\/6653","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=6653"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6653\/revisions"}],"predecessor-version":[{"id":29664,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6653\/revisions\/29664"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}