Merge cells in Excel the way you need them Combine cells, rows, and columns without losing data If you need to combine several cells into one, merge columns row-by-row or rows column-by-column, Merge Cells for Excel is the best assistant for you.
Hello, I recently 'upgraded' from Excel 2011 to Excel 2016 and it looks like I've lost a bit of functionality I use often. In Excel 2011, I could select two or more adjacent cells in a row, copy (command + C), double click in a new blank cell, and paste (command + V) - and the result would be that the content of all the copied cells would now be concatenated into one cell with a space automatically inserted between the content from each of the copied cells. I've made that sound much more complicated than it actually is. Here's an example: A B C D E 1 abcd efgh ijkl mnop 2 In Excel 2011, I could select cells A1, B1, C1, and D1, copy (command + C), double-click in E1 to get the cursor, and paste (command + V), and this would be the result in E1: A B C D E 1 abcd efgh ijkl mnop abcd efgh ijkl mnop 2 When I attempt this in Excel 2016, nothing happens when I paste. I know that I could concatenate these cells by typing a formula in E1: =A1&' '&B1&' '&C1&' '&D1. But it's so much easier to just select, copy, double-click, paste.
I'm hoping someone will respond and tell me there's a setting I need to adjust or something equally simple to regain this function. I apologize if this has already been asked and answered - I've been pouring over the community help forum and it looks like a lot of people have encountered problems with pasting in Excel 2016, but I haven't seen a post matching my issue. The closest I've seen is someone who had this problem pop up sporadically, but (s)he could resolve it by restarting Excel. For me, the problem is constant no matter what I've tried.
I am current on my updates (Excel 15.17, OS X 10.11). Thanks in advance!