★0 XP
Question 1 of 10
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!".
| A | B | C | D | |
|---|---|---|---|---|
| 1 | I | |||
| 2 | love | |||
| 3 | Excel! | |||
| 4 | ||||
| 5 |
A5fx