{"id":352,"date":"2014-04-25T21:19:30","date_gmt":"2014-04-25T19:19:30","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=352"},"modified":"2022-11-03T16:07:53","modified_gmt":"2022-11-03T15:07:53","slug":"excel-convertir-des-donnees","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2014\/04\/excel-convertir-des-donnees\/","title":{"rendered":"Excel &#8211; S\u00e9parer des donn\u00e9es"},"content":{"rendered":"<h4><strong>Contexte<\/strong><\/h4>\n<ul>\n<li>Une colonne \u00ab\u00a0Pr\u00e9nom et Nom\u00a0\u00bb contient des valeurs telles que \u00ab\u00a0Jacqueline Frey\u00a0\u00bb. Vous souhaiteriez s\u00e9parer les pr\u00e9noms des noms dans deux colonnes s\u00e9par\u00e9es.<\/li>\n<\/ul>\n<h4><strong>Solution<\/strong><\/h4>\n<ul>\n<li>S\u00e9lectionnez les valeurs \u00e0 convertir (la colonne \u00ab\u00a0Pr\u00e9nom et Nom)<\/li>\n<li>Allez dans l&rsquo;onglet Donn\u00e9es &gt; bouton Convertir<\/li>\n<li>Dans l&rsquo;Assistant Conversion, choisissez le type \u00ab\u00a0D\u00e9limit\u00e9\u00a0\u00bb<\/li>\n<li>Indiquez quel est le caract\u00e8re de s\u00e9paration, dans notre cas un espace<\/li>\n<li>Indiquez quel est le format des donn\u00e9es, par ex. Standard<\/li>\n<li>Indiquez quelle est la destination (veillez \u00e0 ce qu&rsquo;il n&rsquo;y ait pas d&rsquo;information dans les cellules situ\u00e9es \u00e0 droite de la destination, s&rsquo;il y en a, Excel va les \u00e9craser lors de la conversion)<\/li>\n<li>Validez<\/li>\n<\/ul>\n<p>Cette fonctionnalit\u00e9 est tr\u00e8s utile pour s\u00e9parer des mots-cl\u00e9s qui auraient \u00e9t\u00e9 saisis dans une m\u00eame cellule par ex. (GUERRE CIVILE | LIBAN | POLITIQUE | SYRIE | INSTAURATION DE LA PAIX). Toutefois, cette conversion ne donnera pas de bon r\u00e9sultat dans le cas de 2\u00e8me pr\u00e9nom ou de nom de famille compos\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Une colonne \u00ab\u00a0Pr\u00e9nom et Nom\u00a0\u00bb contient des valeurs telles que \u00ab\u00a0Jacqueline Frey\u00a0\u00bb. Vous souhaiteriez s\u00e9parer les pr\u00e9noms des noms dans deux colonnes s\u00e9par\u00e9es. Solution S\u00e9lectionnez les valeurs&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3806,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"template-full-width-cover.php","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[4],"tags":[25],"class_list":{"0":"post-352","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-conversion"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/352","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/comments?post=352"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/352\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3806"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}