{"id":894,"date":"2014-10-23T18:27:08","date_gmt":"2014-10-23T16:27:08","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=894"},"modified":"2022-08-09T14:54:43","modified_gmt":"2022-08-09T12:54:43","slug":"excel-copier-plusieurs-paragraphes-dans-une-seule-cellule","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2014\/10\/excel-copier-plusieurs-paragraphes-dans-une-seule-cellule\/","title":{"rendered":"Excel &#8211; Copier plusieurs paragraphes dans une seule cellule"},"content":{"rendered":"<p><strong>Contexte<\/strong><\/p>\n<p>Vous disposez d&rsquo;un texte dans Word que vous aimeriez coller dans Excel. Ce texte (par ex. des commentaires ou une proc\u00e9dure&#8230;) est compos\u00e9 de plusieurs paragraphes s\u00e9par\u00e9s par des Enter.<\/p>\n<p>Vous avez bien tent\u00e9 de faire un copier-coller ordinaire mais vous constatez qu&rsquo;Excel change de cellule \u00e0 chaque fois qu&rsquo;un Enter a \u00e9t\u00e9 tap\u00e9 dans Word alors que vous aimeriez en fait que le texte soit contenu dans une seule cellule.<\/p>\n<p><strong>Solution : \u00e9diter la cellule avant de coller le texte<\/strong><\/p>\n<ul>\n<li>Copiez les paragraphes contenus dans Word<\/li>\n<li>Dans Excel, double-cliquez sur la cellule de destination pour l&rsquo;\u00e9diter (votre curseur clignote dans la cellule)<\/li>\n<li>Collez le texte dans la cellule et appuyez sur Enter<\/li>\n<li>Si n\u00e9cessaire, redimensionnez la colonne<\/li>\n<li>Supprimez le Enter inutile figurant \u00e0 la fin du texte<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous disposez d&rsquo;un texte dans Word que vous aimeriez coller dans Excel. Ce texte (par ex. des commentaires ou une proc\u00e9dure&#8230;) est compos\u00e9 de plusieurs paragraphes s\u00e9par\u00e9s&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3351,"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":[],"class_list":{"0":"post-894","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/894","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=894"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/894\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3351"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}