{"id":5411,"date":"2013-02-06T11:30:46","date_gmt":"2013-02-06T00:30:46","guid":{"rendered":"http:\/\/mingersoft.com\/blog\/?p=5411"},"modified":"2013-02-04T20:27:05","modified_gmt":"2013-02-04T09:27:05","slug":"incorporating-carriage-returns-into-formulae-in-excel-spreadsheets","status":"publish","type":"post","link":"https:\/\/mingersoft.com\/blog\/2013\/02\/incorporating-carriage-returns-into-formulae-in-excel-spreadsheets\/","title":{"rendered":"Incorporating Carriage Returns into Formulae in Excel Spreadsheets"},"content":{"rendered":"<p>Following on from yesterday&#8217;s tip on how to search for carriage returns in Excel spreadsheets, here&#8217;s how you can incorporate this non-printable character into your formulae.<\/p>\n<p>The secret sauce for carriage returns is to include\u00a0<strong>CHAR(10)<\/strong> into your formulae.<\/p>\n<p>For instance, if you want to concatenate two cells but put the values on different lines in the same cell you could do the following:<\/p>\n<blockquote><p>=A1&amp;CHAR(10)&amp;B1<\/p><\/blockquote>\n<p>You may need to enable\u00a0<strong>wrap text<\/strong> on cells containing this formula if the result comes out as one lone string of text though.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Following on from yesterday&#8217;s tip on how to search for carriage returns in Excel spreadsheets, here&#8217;s how you can incorporate this non-printable character into your formulae. The secret sauce for carriage returns is to include\u00a0CHAR(10) into your formulae. For instance, if you want to concatenate two cells but put the values on different lines in &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/mingersoft.com\/blog\/2013\/02\/incorporating-carriage-returns-into-formulae-in-excel-spreadsheets\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":4488,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[18],"tags":[411,2246,2022],"class_list":["post-5411","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-excel","tag-microsoft","tag-spreadsheet","item-wrap"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/mingersoft.com\/blog\/wp-content\/uploads\/2012\/07\/Microsoft-Office-Logo.png?fit=400%2C400&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/posts\/5411","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/comments?post=5411"}],"version-history":[{"count":0,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/posts\/5411\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/media\/4488"}],"wp:attachment":[{"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/media?parent=5411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/categories?post=5411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/tags?post=5411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}