Use Excel's TEXTJOIN Function to Combine Text With Delimiter

This video demonstrates how to use Excel's TEXTJOIN function to combine text from multiple cells into one cell. TEXTJOIN also allows you to specify one or more delimiters. A Delimiter is a character like a comma or hyphen used to separate the text values in a single cell.

You might use this technique to combine multiple cells into one separated by commas.
------------------------

[gamergod]

Thank you so much, you just saved me from spending 30 years on a school assignment.

[franciscianci]

Why 3 "-" when only 2 are used?