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

Les applications telles que Microsoft Excel et Google Sheets comprennent une multitude de fonctions pour traiter les donn\u00e9es textuelles. Parmi celles-ci, la fonction TRIM (ou TRONQUER en fran\u00e7ais) est essentielle pour nettoyer et normaliser les donn\u00e9es en \u00e9liminant les espaces superflus dans une cha\u00eene de caract\u00e8res. Explorons le fonctionnement de cette fonction en d\u00e9tail.<\/p>\n

Syntaxe de la fonction<\/h2>\n

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

 TRIM(texte)<\/code> <\/pre>\n
    \n
  • texte<\/strong> : repr\u00e9sente la cha\u00eene de caract\u00e8res ou la r\u00e9f\u00e9rence de cellule contenant le texte \u00e0 nettoyer.<\/li>\n<\/ul>\n
    Exemple :<\/p>\n
     =TRIM(\" Bonjour, le monde! \") \/\/ R\u00e9sultat : \"Bonjour, le monde!\"<\/code> <\/pre>\n
    Cette formule supprime tous les espaces non n\u00e9cessaires au d\u00e9but et \u00e0 la fin de la cha\u00eene, ainsi que les espaces multiples entre les mots, ne laissant qu’un seul espace entre eux.<\/p>\n
    Applications pratiques<\/h2>\n
    Nettoyage des donn\u00e9es import\u00e9es<\/h2>\n
    Lorsque vous importez des donn\u00e9es d’une autre source, il se peut que des entr\u00e9es textuelles contiennent des espaces suppl\u00e9mentaires, susceptibles de provoquer des erreurs lors de traitements ult\u00e9rieurs.<\/p>\n
     A1: \" Paris \" A2: \" New York \" A3: \"Londres \"<\/code> <\/pre>\n
    En utilisant la fonction TRIM, vous pouvez nettoyer ces donn\u00e9es :<\/p>\n
     B1: =TRIM(A1) B2: =TRIM(A2) B3: =TRIM(A3)<\/code> <\/pre>\n
    Cela fournit des cha\u00eenes de caract\u00e8res propres, sans espaces superflus, garantissant un traitement coh\u00e9rent et correct.<\/p>\n
    Pr\u00e9paration des donn\u00e9es pour des analyses am\u00e9lior\u00e9es<\/h2>\n
    Lorsque des employ\u00e9s saisissent manuellement des donn\u00e9es dans un tableau Excel ou Google Sheets, les diff\u00e9rences dans la mani\u00e8re dont les donn\u00e9es sont saisies peuvent entra\u00eener des variations d’espaces qui affectent des fonctionnalit\u00e9s telles que le tri, la recherche et l’analyse.<\/p>\n
    Voici un tableau pour illustrer :<\/p>\n\n\n\n\n
    Nom<\/th>\nEmail<\/th>\n<\/tr>\n
    \u00a0\u00bb Jean Dupont \u00ab\u00a0<\/td>\njeandupont@example.com<\/td>\n<\/tr>\n
    Claire Martin<\/td>\nclairemartin@example.com<\/td>\n<\/tr>\n<\/table>\n
    En nettoyant les noms avec la fonction TRIM, vous assurez l’uniformit\u00e9 de toutes les entr\u00e9es, facilitant ainsi les recherches et le tri :<\/p>\n
     A1: \" Jean Dupont \" -> B1: =TRIM(A1) -> \"Jean Dupont\" A2: \"Claire Martin\" -> B2: =TRIM(A2) -> \"Claire Martin\"<\/code> <\/pre>\n
    Ce nettoyage est essentiel pour maintenir la qualit\u00e9 des donn\u00e9es, surtout lorsqu’elles sont utilis\u00e9es pour des d\u00e9cisions business critiques ou d’autres analyses importantes.<\/p>\n
    En somme, la fonction TRIM est un outil extr\u00eamement pr\u00e9cieux dans la gestion des donn\u00e9es pour assurer que le traitement du texte reste pr\u00e9cis et exempt d’erreurs inutiles dues aux espaces ind\u00e9sir\u00e9s.<\/p>\n","protected":false},"excerpt":{"rendered":"
    CalCule le taux de rentabilit\u00e9 interne lorsque les paiements positifs et n\u00e9gatifs sont finanC\u00e9s \u00e0 des taux diff\u00e9rents<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[311],"tags":[],"class_list":["post-6667","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction MIRR (TRIM) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction MIRR (TRIM) 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\/mirr\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction MIRR (TRIM) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction MIRR (TRIM) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/mirr\/\" \/>\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:27+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction MIRR (TRIM) 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\/mirr\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/mirr\/\",\"name\":\"Fonction MIRR (TRIM) 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:27+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction MIRR (TRIM) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/mirr\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/mirr\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/mirr\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finances\",\"item\":\"https:\/\/functiontranslator.com\/fr\/finances\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TRIM\"}]},{\"@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 MIRR (TRIM) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction MIRR (TRIM) 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\/mirr\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction MIRR (TRIM) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction MIRR (TRIM) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/mirr\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:27+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction MIRR (TRIM) 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\/mirr\/","url":"https:\/\/functiontranslator.com\/fr\/mirr\/","name":"Fonction MIRR (TRIM) 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:27+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction MIRR (TRIM) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/mirr\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/mirr\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/mirr\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Finances","item":"https:\/\/functiontranslator.com\/fr\/finances\/"},{"@type":"ListItem","position":3,"name":"TRIM"}]},{"@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\/6667","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=6667"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6667\/revisions"}],"predecessor-version":[{"id":29678,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6667\/revisions\/29678"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}