Excel TEXTJOIN() Function – Join Multiple Text Values in One Cell

Описание: Learn how to use the TEXTJOIN() function in Excel to combine text from multiple cells into one – with or without separators! This function is perfect for merging names, addresses, or any list of data into a single line. A must-know trick for Excel users!
Formula used: =TEXTJOIN(", ", TRUE, A2:A5)