{"id":6540,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/trouve-trouverb\/"},"modified":"2021-02-26T08:06:17","modified_gmt":"2021-02-26T08:06:17","slug":"find-findbs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/find-findbs\/","title":{"rendered":"TROUVE, TROUVERB"},"content":{"rendered":"

Syntaxe et Description de la Fonction TROUVE<\/h2>\n

La fonction TROUVE dans MS Excel et Google Sheets permet de d\u00e9terminer la position de la premi\u00e8re occurrence d\u2019un texte sp\u00e9cifique au sein d\u2019une cha\u00eene de caract\u00e8res. Elle est particuli\u00e8rement efficace pour localiser la position exacte d\u2019un mot ou d\u2019un fragment de texte.<\/p>\n

Syntaxe de la fonction TROUVE :<\/strong><\/p>\n

TROUVE(texte_cherch\u00e9, texte_dans_lequel_chercher, [num\u00e9ro_d\u00e9part])<\/code><\/pre>\n
    \n
  • texte_cherch\u00e9<\/strong> : le texte \u00e0 rechercher.<\/li>\n
  • texte_dans_lequel_chercher<\/strong> : la cha\u00eene de caract\u00e8res o\u00f9 la recherche est effectu\u00e9e.<\/li>\n
  • num\u00e9ro_d\u00e9part<\/strong> (optionnel) : la position dans le texte \u00e0 partir de laquelle d\u00e9buter la recherche. Si non sp\u00e9cifi\u00e9, la recherche d\u00e9marre au d\u00e9but.<\/li>\n<\/ul>\n
    Exemple :<\/strong><\/p>\n
    =TROUVE(\"jour\", \"Bonjour le monde\")<\/code><\/pre>\n
    Cette formule renvoie 4, indiquant que le mot \u00ab\u00a0jour\u00a0\u00bb commence \u00e0 la quatri\u00e8me position dans le texte \u00ab\u00a0Bonjour le monde\u00a0\u00bb.<\/p>\n
    Cas Pratiques d’Utilisation<\/h2>\n
    Trouver la Position d’un Domaine dans une Adresse Email<\/h2>\n
    Supposons que vous disposiez d’une liste d’adresses email et que vous souhaitiez d\u00e9tecter la position du caract\u00e8re \u00ab\u00a0@\u00a0\u00bb pour diff\u00e9rencier le nom d’utilisateur et le domaine de l’email.<\/p>\n
    =A2 : bond_james@example.com =B2 : =TROUVE(\"@\", A2)<\/code><\/pre>\n
    En entrant cette formule dans la cellule B2, vous obtiendrez 11, ce qui montre que \u00ab\u00a0@\u00a0\u00bb est situ\u00e9 en 11\u00e8me position dans l’adresse email \u00ab\u00a0bond_james@example.com\u00a0\u00bb.<\/p>\n
    Extraction d\u2019une Ann\u00e9e \u00e0 partir d\u2019une Date Formatt\u00e9e en Texte<\/h2>\n
    Imaginons que vous avez des dates format\u00e9es en texte selon le format \u00ab\u00a0JJ-MM-AAAA\u00a0\u00bb et que vous souhaitez en extraire l’ann\u00e9e.<\/p>\n
    =A2 : 25-12-2020 =B2 : =STXT(A2, TROUVE(\"-\", A2, TROUVE(\"-\", A2) + 1) + 1, 4)<\/code><\/pre>\n
    Dans la cellule B2, cette formule extrait l’ann\u00e9e de la date en utilisant TROUVE pour rep\u00e9rer la position du deuxi\u00e8me \u00ab\u00a0–\u00a0\u00bb apr\u00e8s le premier, permettant ainsi \u00e0 STXT d\u2019isoler les quatre caract\u00e8res suivants qui correspondent \u00e0 l’ann\u00e9e.<\/p>\n
    En conclusion, TROUVE est une fonction essentielle pour manipuler et extraire des informations sp\u00e9cifiques dans les cha\u00eenes de texte. Son int\u00e9gration avec d’autres fonctions Excel et Google Sheets la rend indispensable pour les utilisateurs avanc\u00e9s.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Trouve une valeur TexTuelle dans une auTre, en respecTanT 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-6540","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction FIND, FINDBs (TROUVE, TROUVERB) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction FIND, FINDBs (TROUVE, TROUVERB) 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\/find-findbs\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction FIND, FINDBs (TROUVE, TROUVERB) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction FIND, FINDBs (TROUVE, TROUVERB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/find-findbs\/\" \/>\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:06:17+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction FIND, FINDBs (TROUVE, TROUVERB) 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\/find-findbs\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/find-findbs\/\",\"name\":\"Fonction FIND, FINDBs (TROUVE, TROUVERB) 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:06:17+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction FIND, FINDBs (TROUVE, TROUVERB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/find-findbs\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/find-findbs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/find-findbs\/#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\":\"TROUVE, TROUVERB\"}]},{\"@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 FIND, FINDBs (TROUVE, TROUVERB) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction FIND, FINDBs (TROUVE, TROUVERB) 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\/find-findbs\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction FIND, FINDBs (TROUVE, TROUVERB) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction FIND, FINDBs (TROUVE, TROUVERB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/find-findbs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:06:17+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction FIND, FINDBs (TROUVE, TROUVERB) 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\/find-findbs\/","url":"https:\/\/functiontranslator.com\/fr\/find-findbs\/","name":"Fonction FIND, FINDBs (TROUVE, TROUVERB) 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:06:17+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction FIND, FINDBs (TROUVE, TROUVERB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/find-findbs\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/find-findbs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/find-findbs\/#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":"TROUVE, TROUVERB"}]},{"@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\/6540","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=6540"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6540\/revisions"}],"predecessor-version":[{"id":29551,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6540\/revisions\/29551"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}