In my fumble-fingered attempt to copy (supposedly with Ctrl+c) part of a column containing a few text strings in individual cells within new Google Sheets, on pasting (supposedly withCtrl+v) I ended up with the required text strings but all together in the one cell (no spaces) rather than in the same columnar format I started with. The result is not a formula, so can’t be examined for its origins.
Help > Keyboard shortcuts lists a lot of hotkeys (for, in my case, a PC) but nothing that seems to me to be described as having such an effect. Trying all possibilities could take a very long time (if only to unscramble the results from some of them!)
Searching Google for advice, other than through Help as mentioned above, with “google spreadsheet column of cell values into one cell shortcut keys” and similar search terms seems to turn up the same detail as in Help, concatenation formulae or results of little promise.
What key combination might I have pressed to result in such formula-less concatenation?
Maybe this is not as straightforward as I had expected. Additional details:
- Widows 8.1, Firefox 34.0.5
- Select function in Script editor shows four entries: readRows, onOpen, sort and sheetName but nothing in the 57 lines of code seems relevant.
- The range I was expecting to copy was A2:A7 as in the image here. I have moved the cell around since (always in the same sheet) but the content was and still is: