{"id":6758,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/cherche-chercherb\/"},"modified":"2021-02-26T08:13:22","modified_gmt":"2021-02-26T08:13:22","slug":"search-searchbs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/search-searchbs\/","title":{"rendered":"CHERCHE, CHERCHERB"},"content":{"rendered":"

La fonction CHERCHE<\/strong> dans Microsoft Excel et CHECHERB<\/strong> dans Google Sheets permet de trouver la position du d\u00e9but d’une sous-cha\u00eene de texte dans une cha\u00eene de texte plus longue. Elle est essentielle pour analyser et manipuler des donn\u00e9es textuelles. Explorons son fonctionnement, sa syntaxe et des exemples d’utilisation, en mettant en lumi\u00e8re son utilit\u00e9 \u00e0 travers des cas pratiques.<\/p>\n

Syntaxe de la fonction<\/h2>\n

Voici la syntaxe de la fonction CHERCHE :<\/p>\n

 =CHERCHE(texte_cherch\u00e9; texte_total; [position_de_d\u00e9part]) <\/code><\/pre>\n
 O\u00f9 : <\/p>\n
    \n
  • texte_cherch\u00e9<\/strong> : Le texte \u00e0 localiser.<\/li>\n
  • texte_total<\/strong> : Le texte dans lequel la recherche est effectu\u00e9e.<\/li>\n
  • position_de_d\u00e9part [facultatif]<\/strong> : Point de d\u00e9part de la recherche dans le texte. Par d\u00e9faut, la recherche d\u00e9bute au premier caract\u00e8re.<\/li>\n<\/ul>\n
    Exemples d’utilisation simple<\/h2>\n
    Consid\u00e9rons le texte \u00ab\u00a0Bonjour le monde\u00a0\u00bb et vous voulez trouver la position du mot \u00ab\u00a0monde\u00a0\u00bb.<\/p>\n
     =CHERCHE(\"monde\"; \"Bonjour le monde\") <\/code><\/pre>\n
    Cette formule retournera 13, car \u00ab\u00a0monde\u00a0\u00bb appara\u00eet \u00e0 partir de la 13\u00e8me position dans \u00ab\u00a0Bonjour le monde\u00a0\u00bb.<\/p>\n
    Applications pratiques de CHERCHE<\/h2>\n
    Voyons quelques exemples o\u00f9 la fonction CHERCHE se r\u00e9v\u00e8le extr\u00eamement b\u00e9n\u00e9fique.<\/p>\n
    Premier cas pratique : Extraction de sous-cha\u00eenes<\/h2>\n
    Supposons que vous avez une liste d’adresses email et vous voulez en extraire le nom de domaine.<\/p>\n
     Cellule A1 : adresse@example.com Formule dans B1 : =STXT(A1; CHERCHE(\"@\", A1) + 1; NBCAR(A1)) <\/code><\/pre>\n
    Cette approche utilise CHERCHE pour d\u00e9tecter la position du caract\u00e8re \u00ab\u00a0@\u00a0\u00bb, puis STXT extrait la portion de texte subs\u00e9quente jusqu’\u00e0 la fin de la cha\u00eene.<\/p>\n
    Deuxi\u00e8me cas pratique : Validation des donn\u00e9es<\/h2>\n
    Vous souhaitez confirmer la pr\u00e9sence d’un mot cl\u00e9 sp\u00e9cifique dans un texte pour d\u00e9terminer la suite des actions, comme dans un processus de mod\u00e9ration de contenu.<\/p>\n
     Cellule A1 : Il semble que le probl\u00e8me est r\u00e9solu. Formule en B1 : =SI(ESTERREUR(CHERCHE(\"probl\u00e8me\", A1)); \"Non mentionn\u00e9\"; \"Mentionn\u00e9\") <\/code><\/pre>\n
    Cette formule recherche \u00ab\u00a0probl\u00e8me\u00a0\u00bb dans la cellule A1. Si trouv\u00e9, elle affiche \u00ab\u00a0Mentionn\u00e9\u00a0\u00bb. Si non, elle capture l’erreur engendr\u00e9e par CHERCHE et renvoie \u00ab\u00a0Non mentionn\u00e9\u00a0\u00bb.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Trouve un TexTe dans un auTre TexTe (sans respecTer la casse)<\/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-6758","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction SEARCH, SEARCHBs (CHERCHE, CHERCHERB) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SEARCH, SEARCHBs (CHERCHE, CHERCHERB) 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\/search-searchbs\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SEARCH, SEARCHBs (CHERCHE, CHERCHERB) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SEARCH, SEARCHBs (CHERCHE, CHERCHERB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/search-searchbs\/\" \/>\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:13: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 SEARCH, SEARCHBs (CHERCHE, CHERCHERB) 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\/search-searchbs\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/search-searchbs\/\",\"name\":\"Fonction SEARCH, SEARCHBs (CHERCHE, CHERCHERB) 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:13:22+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SEARCH, SEARCHBs (CHERCHE, CHERCHERB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/search-searchbs\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/search-searchbs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/search-searchbs\/#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\":\"CHERCHE, CHERCHERB\"}]},{\"@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 SEARCH, SEARCHBs (CHERCHE, CHERCHERB) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SEARCH, SEARCHBs (CHERCHE, CHERCHERB) 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\/search-searchbs\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SEARCH, SEARCHBs (CHERCHE, CHERCHERB) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SEARCH, SEARCHBs (CHERCHE, CHERCHERB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/search-searchbs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:13:22+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SEARCH, SEARCHBs (CHERCHE, CHERCHERB) 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\/search-searchbs\/","url":"https:\/\/functiontranslator.com\/fr\/search-searchbs\/","name":"Fonction SEARCH, SEARCHBs (CHERCHE, CHERCHERB) 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:13:22+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SEARCH, SEARCHBs (CHERCHE, CHERCHERB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/search-searchbs\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/search-searchbs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/search-searchbs\/#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":"CHERCHE, CHERCHERB"}]},{"@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\/6758","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=6758"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6758\/revisions"}],"predecessor-version":[{"id":29769,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6758\/revisions\/29769"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6758"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}