{"id":6636,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/fonction-jis\/"},"modified":"2021-02-26T08:09:20","modified_gmt":"2021-02-26T08:09:20","slug":"jis","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/jis\/","title":{"rendered":"JIS"},"content":{"rendered":"

La fonction JIS<\/strong> dans Microsoft Excel et Google Sheets permet de convertir des cha\u00eenes de texte en l’encodage JIS (Japanese Industrial Standards) X 0208, utilis\u00e9 pour les caract\u00e8res japonais. Cette fonction est particuli\u00e8rement utile pour assurer la compatibilit\u00e9 des donn\u00e9es avec les normes d’encodage japonaises, essentielles dans certains contextes techniques et professionnels.<\/p>\n

Syntaxe et exemples<\/h2>\n

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

JIS(texte)<\/code><\/pre>\n
o\u00f9 \u00ab\u00a0texte\u00a0\u00bb est la cha\u00eene de caract\u00e8res \u00e0 convertir.<\/p>\n
Exemple :<\/p>\n
=JIS(\"\u3053\u3093\u306b\u3061\u306f\")<\/code><\/pre>\n
Cette formule convertit le texte \u00ab\u00a0\u3053\u3093\u306b\u3061\u306f\u00a0\u00bb dans l’encodage JIS X 0208.<\/p>\n
Utilisation pratique de la fonction<\/h2>\n
La fonction JIS trouve son utilit\u00e9 dans divers sc\u00e9narios, notamment :<\/p>\n
1. Standardisation des donn\u00e9es pour des syst\u00e8mes externes<\/h2>\n
Imaginez que vous travaillez avec une base de donn\u00e9es externe qui exige que toutes les entr\u00e9es en japonais soient encod\u00e9es en JIS pour un traitement ad\u00e9quat. Si vous avez une liste de salutations japonaises dans Excel, vous devriez les convertir avant de les envoyer.<\/p>\n
    \n
  • Vous avez la liste suivante dans la colonne A :<\/li>\n
    A \u3053\u3093\u306b\u3061\u306f \u3055\u3088\u3046\u306a\u3089 \u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3059 \u3059\u307f\u307e\u305b\u3093<\/code><\/pre>\n
  • Pour convertir ces donn\u00e9es, utilisez la fonction JIS dans la colonne B :<\/li>\n
    B =JIS(A1) =JIS(A2) =JIS(A3) =JIS(A4)<\/code><\/pre>\n
  • Cela convertira chaque expression en JIS, rendant les donn\u00e9es compatibles avec votre syst\u00e8me externe.<\/li>\n<\/ul>\n
    2. Cr\u00e9ation de logiciels compatibles avec de vieux syst\u00e8mes japonais<\/h2>\n
    Dans des cas o\u00f9 un logiciel doit \u00eatre compatible avec d’anciens syst\u00e8mes utilisant l’encodage JIS X 0208, il est crucial de convertir tous les textes dans cette norme.<\/p>\n
      \n
    • Consid\u00e9rons un tableau avec les noms de villes japonaises :<\/li>\n\n\n\n\n\n
      Ville<\/th>\n<\/tr>\n
      \u6771\u4eac<\/td>\n<\/tr>\n
      \u5927\u962a<\/td>\n<\/tr>\n
      \u6a2a\u6d5c<\/td>\n<\/tr>\n<\/table>\n
    • Employez la fonction JIS pour chaque nom de ville :<\/li>\n
      =JIS(\"\u6771\u4eac\") =JIS(\"\u5927\u962a\") =JIS(\"\u6a2a\u6d5c\")<\/code><\/pre>\n
    • Ceci garantit que les noms des villes sont correctement encod\u00e9s pour les utiliser dans des syst\u00e8mes anciens.<\/li>\n<\/ul>\n
      En conclusion, la fonction JIS<\/code> est indispensable pour assurer la compatibilit\u00e9 des textes japonais avec les standards requis et avec les syst\u00e8mes n\u00e9cessitant cet encodage sp\u00e9cifique. Sa simplicit\u00e9 d’utilisation dans Excel et Google Sheets en fait un outil pr\u00e9cieux pour ceux qui g\u00e8rent ce type de donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Change les CaraCt\u00e8res \u00e0 demi-Chasse (Cod\u00e9s sur un oCtet) \u00e0 l\u2019int\u00e9rieur d\u2019une Cha\u00eene de CaraCt\u00e8res en CaraCt\u00e8res \u00e0 pleine Chasse (Cod\u00e9s sur deux oCtets)<\/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-6636","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction JIS dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction JIS 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\/jis\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction JIS dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction JIS d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/jis\/\" \/>\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:20+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction JIS 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\/jis\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/jis\/\",\"name\":\"Fonction JIS 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:20+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction JIS d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/jis\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/jis\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/jis\/#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\":\"JIS\"}]},{\"@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 JIS dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction JIS 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\/jis\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction JIS dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction JIS d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/jis\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:09:20+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction JIS 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\/jis\/","url":"https:\/\/functiontranslator.com\/fr\/jis\/","name":"Fonction JIS 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:20+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction JIS d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/jis\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/jis\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/jis\/#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":"JIS"}]},{"@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\/6636","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=6636"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6636\/revisions"}],"predecessor-version":[{"id":29647,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6636\/revisions\/29647"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}