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 o...

Excel_cell combining.pdf35 KB

Formulas and Functions

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.