Description:
Tired of messy CONCATENATE formulas? Meet TEXTJOIN, Excel’s smarter way to combine text from multiple cells — fast and clean! ????
???? Formula used in this video:
=TEXTJOIN(", ", TRUE, A2:A6)
???? Result: Ana, Ben, Cara, David, Emma
???? Bonus examples:
=TEXTJOIN(" - ", TRUE, A2:A6) → Ana - Ben - Cara - David - Emma
=TEXTJOIN(CHAR(10), TRUE, A2:A6) → Each name on a new line (enable Wrap Text!)
Perfect for:
✔ Joining names or product lists
✔ Creating clean CSV-style text
✔ Building emails, labels, and summaries
???? Level up your Excel skills — one formula at a time.
???? Comment your favorite Excel trick below!
???? Like | ???? Subscribe | ???? #ExcelShorts
Share this link via
Or copy link