Jul 01 2020 01:13 AM
Hi,
Can anyone help?
I would like to copy from multiple cells in one spreadsheet but paste into just one cell in another spreadsheet.
Is this possible?
Thanks
E.g.
Literal understanding |
States if a book is the right way up |
Can choose their own photo from choice of 2 |
Recognise pictures of familiar places |
to become
States if a book is the right way up Can choose their own photo from choice of 2 Recognise pictures of familiar places |
Jul 01 2020 01:32 AM - edited Jul 01 2020 01:33 AM
You should be able to use the CONCATENATE function to combine multiple cell (also using carriage return to allow the format you show in your example). Let's assume your data is in cells A2:A4, the following formula will work within the same workbook.
=CONCATENATE(A2,CHAR(10),A3,CHAR(10),A4)
To do this across two workbooks, start typing the formula into the destination workbook and switch between this and the source workbook to select the cells in the formula.
Jan 04 2023 09:41 AM
Jan 04 2023 10:24 AM