combining text from multiple cells into one cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1539165%22%20slang%3D%22en-US%22%3Ecombining%20text%20from%20multiple%20cells%20into%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1539165%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20combine%20text%20into%20multiple%20cells%20into%20one%20cell%20with%20a%20comma%20in%20between%20without%20having%20to%20identify%20the%20comma%20in%20between%20each%20cell.%26nbsp%3B%20Is%20that%20possible%20and%20how%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1539165%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1539231%22%20slang%3D%22en-US%22%3ERe%3A%20combining%20text%20from%20multiple%20cells%20into%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1539231%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F736810%22%20target%3D%22_blank%22%3E%40bhhspro%3C%2FA%3E%26nbsp%3B%20Look%20at%20the%20function%20TEXTJOIN()%2C%20in%20which%20you%20define%20a%20delimitor%20(in%20this%20case%20%22%2C%22)%20to%20put%20between%20each%20of%20the%20strings%20that%20will%20be%20joined.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm trying to combine text into multiple cells into one cell with a comma in between without having to identify the comma in between each cell.  Is that possible and how?

1 Reply

@bhhspro  Look at the function TEXTJOIN(), in which you define a delimitor (in this case ",") to put between each of the strings that will be joined.