TEXTJOIN Function - Free Excel Practice Online

This free, interactive exercise teaches you TEXTJOIN Function in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Text Manipulation Functions track and works right in your browser - no Excel install, no download, and no signup.

Practising TEXTJOIN Function this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this TEXTJOIN Function lesson

1. The TEXTJOIN function lets you join multiple words together with a common separator. The first argument is the separator, the second is whether to ignore blank cells, and the rest are the text you want to join! Type =TEXTJOIN(" ", True, A1:A3) to get "I love Excel!".
2. Remember that the second argument tells TEXTJOIN whether to ignore blank cells. What would =TEXTJOIN(", ", False, A1:A4) return?
3. When the second argument is true, TEXTJOIN ignores blank cells. What would =TEXTJOIN("-", True, A1:A4) return?
4. The separator can be a cell reference. What would =TEXTJOIN(B1, True, A1:A3) return?
5. What would =TEXTJOIN(",", True, "a", "b", "c", "d", "e") return?
6. Write a TEXTJOIN function that returns "Mike, Susan, Bill, Anne"
7. Write a TEXTJOIN function that would return "Iowa*~*Ohio*~*Texas".
8. Write a TEXTJOIN function that would return "651-555-5816".
9. Write a TEXTJOIN function to return "Iowa, Nebraska, South Dakota, Nevada".
10. Write a TEXTJOIN function that returns "MikeBillJeff".

TEXTJOIN Function practice - FAQ