{"id":1219,"date":"2018-01-24T11:13:59","date_gmt":"2018-01-24T03:13:59","guid":{"rendered":"http:\/\/owa.sodexo-cn.com\/blog\/?p=1219"},"modified":"2018-01-25T11:17:43","modified_gmt":"2018-01-25T03:17:43","slug":"excel-handles-multiple-rows-of-data-in-a-cell","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=1219","title":{"rendered":"[Excel] Handles multiple rows of data in a cell"},"content":{"rendered":"<p>&#8220;If you want to say bad habits in Excel, you have to mention Alt+Enter.Because once you use Alt+Enter to force a newline in a cell, the formatting of the entire table becomes less editable. But what happens when you have to meet a cell like this? \u201d<\/p>\n<p>For example, what would you do when a cell contains multiple rows?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1221\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2018\/01\/tips0116-1en.jpg\" alt=\"\" width=\"255\" height=\"126\" \/><\/p>\n<p>If one knocks on a delete to make multiple lines a row, the efficiency is obviously low. If you use a breakdown function, you can simplify these operations.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1195\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2018\/01\/tips0116-2en.gif\" alt=\"\" width=\"853\" height=\"637\" \/><\/p>\n<ul>\n<li>After selecting the cell, click on the breakdown function and select the split symbol<\/li>\n<li>You will find that under the default option, all data in the cell is not correctly identified, and only the first row in the cell is recognized. At this point, you need to cancel other options, and then tick the other and type <strong>Ctrl + J<\/strong>. You can see a small cursor flashing, and all the data is sorted into columns.<\/li>\n<\/ul>\n<p>In this example, the most important is the shortcut key <strong>Ctrl + J<\/strong>, which is used to locate all the carriage returns that are generated by Alt+Enter.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;If you want to say bad habits in Excel, you have &#8230; <a title=\"[Excel] Handles multiple rows of data in a cell\" class=\"read-more\" href=\"https:\/\/owa.sodexo-cn.com\/blog\/?p=1219\" aria-label=\"\u9605\u8bfb [Excel] Handles multiple rows of data in a cell\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1219","post","type-post","status-publish","format-standard","hentry","category-tips"],"views":2235,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1219"}],"version-history":[{"count":2,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1219\/revisions"}],"predecessor-version":[{"id":1222,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1219\/revisions\/1222"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}