Submitted by jimspoon on 2023/05/14 17:58

Say you want to copy the content of two cells (call them A1 and B1, as in a spreadsheet) to two other cells (call them A2 and B2).

In Excel, you'd select A1 and B1, press Ctrl+C, then select A, and press Ctrl+V to paste.  A2 now has the same content as A1, and B2 now has the same content as B1.

If you do this in IQ, the content of A1 and B1 is concatenated and inserted into A2; B2 remains empty.  But if you first select BOTH A2 and B2, then press Ctrl+V, the A1 content is pasted into A2, and B1 content is pasted into B2, "spreadsheet style".  Just something to keep in mind.

 

How do I ?