Forum Discussion

Harryc44's avatar
Harryc44
Copper Contributor
Jul 30, 2021

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

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

Formulas and Functions

3 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jul 30, 2021

    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.

Resources