{"id":1974,"date":"2016-06-23T15:10:26","date_gmt":"2016-06-23T13:10:26","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=1974"},"modified":"2022-08-10T15:30:40","modified_gmt":"2022-08-10T13:30:40","slug":"excel-contourner-la-recherche-de-caracteres-generiques-point-dinterrogation","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2016\/06\/excel-contourner-la-recherche-de-caracteres-generiques-point-dinterrogation\/","title":{"rendered":"Excel &#8211; Contourner la recherche de caract\u00e8res g\u00e9n\u00e9riques (point d&rsquo;interrogation)"},"content":{"rendered":"<h4><strong>Contexte<\/strong><\/h4>\n<p>Dans plusieurs\u00a0cellules d&rsquo;un immense tableau Excel, vous avez saisi des points d&rsquo;interrogation ? (parce que vous ignoriez les valeurs au moment de la cr\u00e9ation du tableau\u00a0et vous vous \u00e9tiez dit que des ? feraient l&rsquo;affaire&#8230;). Vous souhaitez maintenant pouvoir retrouver facilement les ? afin de compl\u00e9ter les donn\u00e9es. Bien entendu, vous avez saisi un ? dans la zone de recherche. Excel consid\u00e9rant ce caract\u00e8re comme \u00e9tant g\u00e9n\u00e9rique, il trouve toutes les cellules dans lesquelles vous avez saisi des donn\u00e9es \ud83d\ude41 .<\/p>\n<h4><strong>Solution<\/strong><\/h4>\n<ul>\n<li>Tapez un tilde avant le ? dans la zone de recherche (~?) ; Excel ne trouvera que les cellules contenant r\u00e9ellement un ?<\/li>\n<\/ul>\n<p>PS : le tilde s&rsquo;obtient \u00e0 l&rsquo;aide des touches Alt + n sur Mac (Alt-Gr +\u00a0^ sur PC)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Dans plusieurs\u00a0cellules d&rsquo;un immense tableau Excel, vous avez saisi des points d&rsquo;interrogation ? (parce que vous ignoriez les valeurs au moment de la cr\u00e9ation du tableau\u00a0et vous&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3576,"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":[40],"class_list":{"0":"post-1974","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-recherche"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/1974","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=1974"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/1974\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3576"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=1974"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=1974"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=1974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}