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

Description g\u00e9n\u00e9rale<\/h2>\n

La fonction REPT, disponible dans Microsoft Excel et Google Sheets, permet de r\u00e9p\u00e9ter un texte un nombre d\u00e9fini de fois. Elle s’av\u00e8re particuli\u00e8rement utile pour dupliquer des cha\u00eenes de caract\u00e8res, pour mettre en forme des documents, ou encore pour cr\u00e9er des visualisations de donn\u00e9es de mani\u00e8re efficace et esth\u00e9tique.<\/p>\n

Syntaxe de la fonction<\/h2>\n

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

REPT(texte, nombre)<\/code><\/pre>\n
Les param\u00e8tres sont d\u00e9finis comme suit :<\/p>\n
    \n
  • texte<\/strong> : la cha\u00eene de caract\u00e8res que vous souhaitez r\u00e9p\u00e9ter.<\/li>\n
  • nombre<\/strong> : le nombre de fois que le texte sera r\u00e9p\u00e9t\u00e9. Ce param\u00e8tre doit \u00eatre un nombre entier positif.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Pour illustrer, si vous voulez r\u00e9p\u00e9ter le mot \u00ab\u00a0Bonjour\u00a0\u00bb cinq fois, vous utiliserez la formule suivante :<\/p>\n
    =REPT(\"Bonjour \", 5)<\/code><\/pre>\n
    Le r\u00e9sultat sera :<\/p>\n
     \"Bonjour Bonjour Bonjour Bonjour Bonjour \"<\/code> <\/p>\n
    Sc\u00e9narios d’application<\/h2>\n
    T\u00e2che 1: Cr\u00e9ation de lignes de s\u00e9paration<\/h2>\n
    Probl\u00e8me<\/strong> : Vous r\u00e9digez un document et avez besoin de lignes de s\u00e9paration, compos\u00e9es de tirets, pour distinguer clairement les diff\u00e9rentes sections.<\/p>\n
    Solution<\/strong> :<\/p>\n
    =REPT(\"-\", 20)<\/code><\/pre>\n
    Cette formule g\u00e9n\u00e9rera une ligne de 20 tirets, que vous pouvez adapter en longueur selon vos besoins.<\/p>\n
    T\u00e2che 2: Visualisation de donn\u00e9es<\/h2>\n
    Probl\u00e8me<\/strong> : Vous d\u00e9sirez repr\u00e9senter des donn\u00e9es chiffr\u00e9es de mani\u00e8re graphique simple, comme illustrer le volume des ventes avec des \u00e9toiles en fonction du nombre d’unit\u00e9s vendues.<\/p>\n
    Solution<\/strong> :<\/p>\n
    Imaginons que la cellule A1 contienne le nombre d’unit\u00e9s vendues (par exemple, 5). Utilisez la formule suivante pour une repr\u00e9sentation visuelle sous forme d’\u00e9toiles :<\/p>\n
    =REPT(\"\u2605 \", A1)<\/code><\/pre>\n
    Si A1 contient le chiffre 5, le r\u00e9sultat affich\u00e9 sera :<\/p>\n
     \"\u2605 \u2605 \u2605 \u2605 \u2605 \"<\/code> <\/p>\n
    Cette m\u00e9thode est id\u00e9ale pour des rapports n\u00e9cessitant une visualisation rapide et intuitive des r\u00e9sultats, sans recourir \u00e0 des graphiques complexes.<\/p>\n","protected":false},"excerpt":{"rendered":"
    R\u00e9p\u00e8te un texte un ceRtain nombRe de fois<\/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-6747","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction REPT dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction REPT 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\/rept\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction REPT dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction REPT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/rept\/\" \/>\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:56+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction REPT 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\/rept\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/rept\/\",\"name\":\"Fonction REPT 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:56+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction REPT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/rept\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/rept\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/rept\/#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\":\"REPT\"}]},{\"@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 REPT dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction REPT 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\/rept\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction REPT dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction REPT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/rept\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:12:56+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction REPT 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\/rept\/","url":"https:\/\/functiontranslator.com\/fr\/rept\/","name":"Fonction REPT 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:56+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction REPT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/rept\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/rept\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/rept\/#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":"REPT"}]},{"@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\/6747","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=6747"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6747\/revisions"}],"predecessor-version":[{"id":29758,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6747\/revisions\/29758"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}