{"id":32,"date":"2018-12-26T07:03:27","date_gmt":"2018-12-26T07:03:27","guid":{"rendered":"https:\/\/www.howtoexcel.info\/Excel\/?p=32"},"modified":"2018-12-28T05:37:30","modified_gmt":"2018-12-28T05:37:30","slug":"combinecellcontents","status":"publish","type":"post","link":"https:\/\/www.howtoexcel.info\/Excel\/combinecellcontents\/","title":{"rendered":"How to combine multiple cells in excel without losing data?"},"content":{"rendered":"\r\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\"> Easiest way to do this is by the use of ampersand, ie. =A&amp;B<br \/>If Cell 1=A and Cell 2=B, then the contents of both cells can be merged within Cell 3 by applying formula =Cell1&amp;Cell2. Please refer to the following excel spreadsheet for example.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" width=\"578\" height=\"401\" class=\"wp-image-36\" src=\"https:\/\/www.howtoexcel.info\/Excel\/wp-content\/uploads\/2018\/12\/combinecellcontents.jpg\" alt=\"\" srcset=\"https:\/\/www.howtoexcel.info\/Excel\/wp-content\/uploads\/2018\/12\/combinecellcontents.jpg 578w, https:\/\/www.howtoexcel.info\/Excel\/wp-content\/uploads\/2018\/12\/combinecellcontents-300x208.jpg 300w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #ffffff;\"><span style=\"color: #000000; font-size: 12px;\"> <b>Search engine keywords for this question<\/b><\/span><br \/><span style=\"color: #000000; font-size: 10px;\">\u00a0<span style=\"color: #000000;\">How to combine excel cell contents?<\/span><br \/><span style=\"color: #000000;\">\u00a0How to combine separate cells info?<\/span><br \/>\u00a0How to combine two cells together?<br \/>\u00a0How to add together two cells contents?<br \/>\u00a0How to add two adjacent cells information?<br \/>\u00a0How to merge two continuous cells contents?<br \/>\u00a0Combine numbers from two cells<br \/>\u00a0Merging contents without deleting<br \/>\u00a0How to concatenate two adjacent cells?<br \/>\u00a0How to merge cells without deleting?<br \/>\u00a0How to join excel columns?<br \/>\u00a0How to combine columns without deleting?<br \/>\u00a0How to combine rows without losing cell contents?<br \/>\u00a0How to join columns in excel?<br \/>\u00a0Show two cells contents together<br \/>\u00a0Display two cells quantities together<br \/>\u00a0Combine multiple cells text content<br \/>\u00a0Merge and show numerals from two adjacent cells<br \/>\u00a0Merge two or more adjacent cells and combine into one single cell<\/span><\/span><\/p>\r\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/32"}],"collection":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/comments?post=32"}],"version-history":[{"count":5,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/32\/revisions"}],"predecessor-version":[{"id":174,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/32\/revisions\/174"}],"wp:attachment":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/media?parent=32"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/categories?post=32"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/tags?post=32"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}