https:\/\/answers.microsoft.com\/en-us\/office\/forum\/office_2007-excel\/retain-multi-line-cells-when-pasting-word-table\/c16c4831-a9c7-47b8-8d0d-94ef53c3cbdd?auth=1<\/a> <\/p>\nIn Word, select the table. <\/p>\n
Press Ctrl+H to activate the replace dialog. <\/p>\n
Enter ^p in the Find what box. <\/p>\n
Enter some text that doesn’t occur otherwise in the Replace with box, for example @@@@. <\/p>\n
Click Replace All and don’t allow it to continue beyond the table. <\/p>\n
Close the Replace dialog. <\/p>\n
Copy \/ paste the table into Excel. <\/p>\n
Press Ctrl+H to activate the replace dialog. <\/p>\n
Enter @@@@ (or whatever you used in Word) in the Find what box. <\/p>\n
Press Alt+0010 in the Replace with box. <\/p>\n
Click Options >> and make sure that the “Match entire cell contents” check box is clear. <\/p>\n
Click Replace All. <\/p>\n
You may have to format the cells to wrap text.<\/p>\n","protected":false},"excerpt":{"rendered":"
https:\/\/answers.microsoft.com\/en-us\/office\/forum\/office_2007-excel\/retain-multi-line-cells-when-pasting-word-table\/c16c4831-a9c7-47b8-8d0d-94ef53c3cbdd?auth=1 In Word, select the table. Press Ctrl+H to activate the replace dialog. Enter ^p in the Find what box. Enter some text that doesn’t occur otherwise in the Replace with box, for example @@@@. Click Replace All and don’t allow it to continue beyond the table. Close the Replace dialog. Copy \/ paste […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-640","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts\/640","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=640"}],"version-history":[{"count":1,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts\/640\/revisions"}],"predecessor-version":[{"id":641,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts\/640\/revisions\/641"}],"wp:attachment":[{"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=640"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}