Harryc44Copper ContributorJul 30, 2021CONCAT function Concatenating text from several cells of one row into one separate cell in the same row. I want to apply that formula to each successive entry in the rows that follow the first row. my example of o...Show MoreExcel_cell combining.pdf35 KB
Harryc44Copper ContributorJul 31, 2021NikolinoDE Hello Nikolino... Elegant solution - see attached.Thank you, HarryTextJoin function - excellent.pdf47 KB
SergeiBaklanDiamond Contributor to Harryc44Jul 31, 2021Harryc44 You may simplify a bit =TEXTJOIN(", ",1,D2,G2,J2,M2:Q2)
