Jun 02 2022 01:00 AM - edited Jun 02 2022 01:03 AM
Previously I could copy information from 2 + cells in excel file to 1 cell in another excel file. Since my 365 update this no longer works. I checked with another colleague and they can still do this after the update so think it could be an issue with my excel settings or something. Not entirely sure to be honest but It is very time consuming during month to not have this option so hoping someone can help.
Jun 02 2022 01:16 AM
@Hans Vogelaar to copy a and b to one cell in another excel :)
Jun 02 2022 01:21 AM
Jun 02 2022 02:23 AM
Although it's still possible, recent versions of Excel have indeed made that much more difficult.
As a workaround, copy the cells (Ctrl+C), then paste them into Notepad (Ctrl+V).
Select the pasted text, and copy it (Ctrl+C).
Switch to the target workbook, and select the target cell.
Press F2 to edit the cell, then Ctrl+V to paste.
Jun 02 2022 02:44 AM