CONCAT function

[Harryc44]

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 one row  -  =CONCAT(D6,", "&G6," , "&J6,", "&M6,", "&N6)

How do I apply that formula to apply to "n" rows below?

[#2]

@Harryc44 

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2019 Excel 2019 for Mac

TEXTJOIN

The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

Note: This feature is available on Windows or Mac if you have Office 2019, or if you have a Microsoft 365 subscription. If you are a Microsoft 365 subscriber, make sure you have the latest version of Office.

Hope I could help you with this information.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

[#3]

@NikolinoDE 

Hello Nikolino...

 Elegant solution - see attached.

Thank you, Harry

[#4]

@Harryc44 

You may simplify a bit

=TEXTJOIN(", ",1,D2,G2,J2,M2:Q2)