Home

Merge contents of several cells in one cell

%3CLINGO-SUB%20id%3D%22lingo-sub-299307%22%20slang%3D%22en-US%22%3EMerge%20contents%20of%20several%20cells%20in%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299307%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20people!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20got%20a%20question%20I%20wasn't%20able%20to%20find%20an%20answer%20to%20using%20the%20search%20function...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20merge%20the%20content%20of%20several%20cells%20(A2%2C%20A3%2C%20A4%20etc.%20all%20the%20way%20down%20to%20A99)%26nbsp%3B%20into%20one%20(B2)%2C%20separated%20with%20a%20semicolon%20and%20a%20space%26nbsp%3B%20-%20without%20doing%20all%20this%20manually.%20Any%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20this%20formula%26nbsp%3B%3DA2%26amp%3B%22%3B%20%22%26amp%3BA3%20-%20but%20how%20do%26nbsp%3BI%20do%20this%20all%20the%20way%20down%20to%20A99%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-299307%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299317%22%20slang%3D%22en-US%22%3ERe%3A%20Merge%20contents%20of%20several%20cells%20in%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299317%22%20slang%3D%22en-US%22%3E%3CP%3EOkay%2C%20I%20think%20I%20found%20the%20answer%20myself%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DTEXTJOIN(%22%3B%20%22%2C%20TRUE%2C%20A2%3AA99)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3A)%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Doro13
New Contributor

Hi people! 

 

I've got a question I wasn't able to find an answer to using the search function...

 

I want to merge the content of several cells (A2, A3, A4 etc. all the way down to A99)  into one (B2), separated with a semicolon and a space  - without doing all this manually. Any suggestions?

 

I know this formula =A2&"; "&A3 - but how do I do this all the way down to A99?

 

Thanks in advance! 

1 Reply

Okay, I think I found the answer myself: 

 

=TEXTJOIN("; ", TRUE, A2:A99)

 

:) 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies