{"id":6640,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/gauche-gaucheb\/"},"modified":"2021-02-26T08:09:38","modified_gmt":"2021-02-26T08:09:38","slug":"left-leftbs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/left-leftbs\/","title":{"rendered":"GAUCHE, GAUCHEB"},"content":{"rendered":"

La fonction GAUCHE dans Excel et Google Sheets sert \u00e0 extraire un nombre sp\u00e9cifi\u00e9 de caract\u00e8res depuis le d\u00e9but d’une cha\u00eene de texte. Cette fonction est particuli\u00e8rement pr\u00e9cieuse pour subdiviser des cha\u00eenes de texte en segments plus courts, simplifier les analyses textuelles, ou reformater des donn\u00e9es. Pour les cha\u00eenes comprenant des caract\u00e8res \u00e0 double octet, utilisez GAUCHEB.<\/p>\n

Comprendre la syntaxe<\/h2>\n

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

=GAUCHE(texte; [nombre_de_caract\u00e8res])<\/code><\/pre>\n
    \n
  • texte :<\/strong> La cha\u00eene de caract\u00e8res ou la r\u00e9f\u00e9rence \u00e0 une cellule d’o\u00f9 extraire les caract\u00e8res.<\/li>\n
  • nombre_de_caract\u00e8res :<\/strong> Le nombre de caract\u00e8res \u00e0 extraire depuis le d\u00e9but du texte. Si omis, la fonction extrait un seul caract\u00e8re.<\/li>\n<\/ul>\n
    Exemples de la syntaxe en situation r\u00e9elle<\/h2>\n
    =GAUCHE(\"Bonjour tout le monde\", 7) \/\/ Renvoie \"Bonjour\" =GAUCHE(A1; 4) \/\/ Assume que A1 contient \"Entreprise\", renvoie \"Entr\"<\/code><\/pre>\n
    Applications pratiques<\/h2>\n
    Voici quelques sc\u00e9narios o\u00f9 la fonction GAUCHE peut \u00eatre extr\u00eamement utile :<\/p>\n
    Extraction de pr\u00e9noms<\/h2>\n
    Pour extraire les pr\u00e9noms d’une liste de noms complets dans une colonne :<\/p>\n
    \/\/ Cellule A1: Jean Dupont =GAUCHE(A1; TROUVE(\" \"; A1) - 1) \/\/ Renvoie \"Jean\"<\/code><\/pre>\n
    Ce calcul identifie l’espace (\u00a0\u00bb \u00ab\u00a0) s\u00e9parant le pr\u00e9nom et le nom, puis extrait le pr\u00e9nom.<\/p>\n
    R\u00e9duction de codes produits<\/h2>\n
    Pour raccourcir des codes produits longs et g\u00e9n\u00e9rer des identifiants plus courts pratiques pour l’\u00e9tiquetage ou les r\u00e9f\u00e9rences de base de donn\u00e9es :<\/p>\n
    \/\/ Cellule A2: PROD987654321 =GAUCHE(A2; 8) \/\/ Renvoie \"PROD9876\"<\/code><\/pre>\n
    Cet exemple illustre comment simplifier un code produit pour des usages tels que les \u00e9tiquettes de prix ou les r\u00e9f\u00e9rencements dans des bases de donn\u00e9es simplifi\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie des caRact\u00e8Res situ\u00e9s \u00e0 l\u2019extR\u00eame gauche d\u2019une cha\u00eene de caRact\u00e8Res<\/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-6640","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction LEFT, LEFTBs (GAUCHE, GAUCHEB) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction LEFT, LEFTBs (GAUCHE, GAUCHEB) 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\/left-leftbs\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction LEFT, LEFTBs (GAUCHE, GAUCHEB) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction LEFT, LEFTBs (GAUCHE, GAUCHEB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/left-leftbs\/\" \/>\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:09:38+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction LEFT, LEFTBs (GAUCHE, GAUCHEB) 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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/left-leftbs\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/left-leftbs\/\",\"name\":\"Fonction LEFT, LEFTBs (GAUCHE, GAUCHEB) 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:09:38+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction LEFT, LEFTBs (GAUCHE, GAUCHEB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/left-leftbs\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/left-leftbs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/left-leftbs\/#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\":\"GAUCHE, GAUCHEB\"}]},{\"@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 LEFT, LEFTBs (GAUCHE, GAUCHEB) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction LEFT, LEFTBs (GAUCHE, GAUCHEB) 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\/left-leftbs\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction LEFT, LEFTBs (GAUCHE, GAUCHEB) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction LEFT, LEFTBs (GAUCHE, GAUCHEB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/left-leftbs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:09:38+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction LEFT, LEFTBs (GAUCHE, GAUCHEB) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/left-leftbs\/","url":"https:\/\/functiontranslator.com\/fr\/left-leftbs\/","name":"Fonction LEFT, LEFTBs (GAUCHE, GAUCHEB) 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:09:38+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction LEFT, LEFTBs (GAUCHE, GAUCHEB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/left-leftbs\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/left-leftbs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/left-leftbs\/#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":"GAUCHE, GAUCHEB"}]},{"@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\/6640","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=6640"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6640\/revisions"}],"predecessor-version":[{"id":29651,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6640\/revisions\/29651"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6640"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}