Text =TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with])

Quiz =TEXTSPLIT — 10 Questions

10 quiz questions about =TEXTSPLIT — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← TEXTSPLIT ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Does =TEXTSPLIT return a dynamic array?

Question 2 of 10 2/10

Is argument “match_mode” required in =TEXTSPLIT?

Question 3 of 10 3/10

What is the type of argument “match_mode” in =TEXTSPLIT?

Question 4 of 10 4/10

What is the type of argument “ignore_empty” in =TEXTSPLIT?

Question 5 of 10 5/10

What usually causes #N/A in =TEXTSPLIT?

Question 6 of 10 6/10

Is argument “text” required in =TEXTSPLIT?

Question 7 of 10 7/10

Is argument “col_delimiter” required in =TEXTSPLIT?

Question 8 of 10 8/10

Which category does =TEXTSPLIT belong to?

Question 9 of 10 9/10

What is the type of argument “text” in =TEXTSPLIT?

Question 10 of 10 10/10

Is =TEXTSPLIT volatile?

Click a question to see the answer.

1. Does =TEXTSPLIT return a dynamic array?

A. —
B. No
C. Yes ✓
D. Yes

Explanation: TEXTSPLIT spills as a dynamic array.

2. Is argument “match_mode” required in =TEXTSPLIT?

A. No ✓
B. —
C. No
D. Yes

Explanation: “match_mode” is optional.

3. What is the type of argument “match_mode” in =TEXTSPLIT?

A. Mixed
B. Number ✓
C. Value
D. Array

Explanation: Type of “match_mode” is “Number”.

4. What is the type of argument “ignore_empty” in =TEXTSPLIT?

A. Logical ✓
B. Value
C. Array
D. Text

Explanation: Type of “ignore_empty” is “Logical”.

5. What usually causes #N/A in =TEXTSPLIT?

A. Output is always a dynamic array
B. Text is always ignored
C. The default is #N/A. ✓
D. Requires add-in

Explanation: The default is #N/A. — Fix: اگر می‌خواهید به جای #N/A مقدار دیگری نمایش داده شود، آرگومان pad_with را با مقدار دلخواه پر کنید.

6. Is argument “text” required in =TEXTSPLIT?

A. No
B. Yes ✓
C. Yes
D. —

Explanation: “text” is required.

7. Is argument “col_delimiter” required in =TEXTSPLIT?

A. No
B. No ✓
C. Yes
D. —

Explanation: “col_delimiter” is optional.

8. Which category does =TEXTSPLIT belong to?

A. Logical
B. Text ✓
C. Engineering
D. Lookup & Reference

Explanation: Category is “Text”.

9. What is the type of argument “text” in =TEXTSPLIT?

A. Text ✓
B. Mixed
C. Reference
D. Array

Explanation: Type of “text” is “Text”.

10. Is =TEXTSPLIT volatile?

A. No
B. —
C. No ✓
D. Yes

Explanation: TEXTSPLIT is not volatile.