Copy from multiple cells - paste into one

%3CLINGO-SUB%20id%3D%22lingo-sub-1500834%22%20slang%3D%22en-US%22%3ECopy%20from%20multiple%20cells%20-%20paste%20into%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1500834%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3ECan%20anyone%20help%3F%3C%2FP%3E%3CP%3EI%20would%20like%20to%20copy%20from%20multiple%20cells%20in%20one%20spreadsheet%20but%20paste%20into%20just%20one%20cell%20in%20another%20spreadsheet.%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EE.g.%3C%2FP%3E%3CTABLE%20width%3D%22764%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22764%22%20height%3D%2220%22%3E%3CSTRONG%3ELiteral%20understanding%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3EStates%20if%20a%20book%20is%20the%20right%20way%20up%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3ECan%20choose%20their%20own%20photo%20from%20choice%20of%202%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3ERecognise%20pictures%20of%20familiar%20places%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eto%20become%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22415%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22415%22%20height%3D%2260%22%3EStates%20if%20a%20book%20is%20the%20right%20way%20up%3CBR%20%2F%3ECan%20choose%20their%20own%20photo%20from%20choice%20of%202%3CBR%20%2F%3ERecognise%20pictures%20of%20familiar%20places%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1500834%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1500859%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20from%20multiple%20cells%20-%20paste%20into%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1500859%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F715205%22%20target%3D%22_blank%22%3E%40sclyde%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20should%20be%20able%20to%20use%20the%20CONCATENATE%20function%20to%20combine%20multiple%20cell%20(also%20using%20carriage%20return%20to%20allow%20the%20format%20you%20show%20in%20your%20example).%26nbsp%3B%20Let's%20assume%20your%20data%20is%20in%20cells%20A2%3AA4%2C%20the%20following%20formula%20will%20work%20within%20the%20same%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DCONCATENATE(A2%2CCHAR(10)%2CA3%2CCHAR(10)%2CA4)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20do%20this%20across%20two%20workbooks%2C%20start%20typing%20the%20formula%20into%20the%20destination%20workbook%20and%20switch%20between%20this%20and%20the%20source%20workbook%20to%20select%20the%20cells%20in%20the%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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
1 Reply

@sclyde 

 

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.