{"id":6628,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/estnontexte\/"},"modified":"2021-02-26T08:09:03","modified_gmt":"2021-02-26T08:09:03","slug":"isnontext","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/isnontext\/","title":{"rendered":"ESTNONTEXTE"},"content":{"rendered":"

Introduction \u00e0 la fonction pour v\u00e9rifier le type de donn\u00e9es non-textuelles<\/h2>\n

La fonction ESTNONTEXTE dans Microsoft Excel et Google Sheets est utilis\u00e9e pour d\u00e9terminer si une valeur donn\u00e9e n’est pas du texte. Cette fonction est tr\u00e8s utile pour v\u00e9rifier le type de donn\u00e9es dans une cellule avant de proc\u00e9der \u00e0 des op\u00e9rations qui n\u00e9cessitent un type de donn\u00e9es sp\u00e9cifique.<\/p>\n

Syntaxe et Exemples<\/h2>\n

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

=ESTNONTEXTE(valeur)<\/code><\/pre>\n
O\u00f9 valeur<\/code> repr\u00e9sente la valeur \u00e0 tester. La fonction renvoie TRUE si la valeur<\/code> n’est pas un texte, et FALSE si elle l’est.<\/p>\n
Exemple:<\/p>\n
    \n
  • =ESTNONTEXTE(\"texte\")<\/code> renvoie FALSE car \u00ab\u00a0texte\u00a0\u00bb est une cha\u00eene de caract\u00e8res.<\/li>\n
  • =ESTNONTEXTE(123)<\/code> renvoie TRUE car 123 est un nombre, pas du texte.<\/li>\n<\/ul>\n
    Utilisation Pratique dans Des Situations R\u00e9elles<\/h2>\n
    Premier sc\u00e9nario – Filtrage des donn\u00e9es textuelles:<\/p>\n
    Imaginons que vous avez une liste mixte de valeurs textuelles et num\u00e9riques dans une colonne et que vous voulez identifier toutes les non-textes pour les traiter diff\u00e9remment. Voici comment cela pourrait \u00eatre configur\u00e9:<\/p>\n
    Colonne A A1: 42 A2: \"Bonjour\" A3: 76.5 A4: \"Monde\" A5: TRUE Formule: B1: =ESTNONTEXTE(A1) B2: =ESTNONTEXTE(A2) B3: =ESTNONTEXTE(A3) B4: =ESTNONTEXTE(A4) B5: =ESTNONTEXTE(A5) R\u00e9sultats: B1: TRUE B2: FALSE B3: TRUE B4: FALSE B5: TRUE<\/code><\/pre>\n
    Cela permet de voir rapidement quelles cellules contiennent des donn\u00e9es qui ne sont pas des textes.<\/p>\n
    Deuxi\u00e8me sc\u00e9nario – Validation des entr\u00e9es de formulaire:<\/p>\n
    Supposons que vous avez un formulaire o\u00f9 certaines entr\u00e9es doivent \u00eatre strictement num\u00e9riques. Vous pouvez utiliser cette fonction pour valider les entr\u00e9es:<\/p>\n
    Si =ESTNONTEXTE(cellule_d'entr\u00e9e) alors ' Afficher un message d'erreur demandant une entr\u00e9e num\u00e9rique Sinon ' Continuer avec le traitement des donn\u00e9es<\/code><\/pre>\n
    Cette m\u00e9thode offre une mani\u00e8re simple de s’assurer que les donn\u00e9es entr\u00e9es sont du format attendu avant de continuer avec d’autres calculs ou manipulations.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie VRAI si l\u2019aRgument valeuR ne se pR\u00e9sente pas sous foRme de texte<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[319],"tags":[],"class_list":["post-6628","post","type-post","status-publish","format-standard","hentry","category-informations"],"acf":[],"yoast_head":"\nFonction ISNONTEXT (ESTNONTEXTE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ISNONTEXT (ESTNONTEXTE) 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\/isnontext\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ISNONTEXT (ESTNONTEXTE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ISNONTEXT (ESTNONTEXTE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/isnontext\/\" \/>\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:03+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ISNONTEXT (ESTNONTEXTE) 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\/isnontext\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/isnontext\/\",\"name\":\"Fonction ISNONTEXT (ESTNONTEXTE) 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:03+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ISNONTEXT (ESTNONTEXTE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/isnontext\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/isnontext\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/isnontext\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Informations\",\"item\":\"https:\/\/functiontranslator.com\/fr\/informations\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ESTNONTEXTE\"}]},{\"@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 ISNONTEXT (ESTNONTEXTE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ISNONTEXT (ESTNONTEXTE) 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\/isnontext\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ISNONTEXT (ESTNONTEXTE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ISNONTEXT (ESTNONTEXTE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/isnontext\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:09:03+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ISNONTEXT (ESTNONTEXTE) 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\/isnontext\/","url":"https:\/\/functiontranslator.com\/fr\/isnontext\/","name":"Fonction ISNONTEXT (ESTNONTEXTE) 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:03+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ISNONTEXT (ESTNONTEXTE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/isnontext\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/isnontext\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/isnontext\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Informations","item":"https:\/\/functiontranslator.com\/fr\/informations\/"},{"@type":"ListItem","position":3,"name":"ESTNONTEXTE"}]},{"@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\/6628","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=6628"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6628\/revisions"}],"predecessor-version":[{"id":29639,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6628\/revisions\/29639"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}