SPLIT function in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to split the text in cell A1 by commas.

Google Sheets

=SPLIT(A1, [1])

Drag options to blanks, or click blank then click option'

A;

B,

C" "

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using a semicolon or space instead of a comma as delimiter.

Forgetting to put the delimiter inside quotes.

The SPLIT function separates text based on the delimiter you provide. Here, the delimiter is a comma, so the text in A1 will be split at each comma.

2fill in blank

medium

Complete the code to split the text in cell B2 by a space character.

Google Sheets

=SPLIT(B2, [1])

Drag options to blanks, or click blank then click option'

A,

B" "

C;

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using comma or semicolon instead of space.

Not using quotes around the delimiter.

To split text by spaces, use a space character as the delimiter inside quotes.

3fill in blank

hard

Fix the error in the formula to split text in C3 by a dash.

Google Sheets

=SPLIT(C3, [1])

Drag options to blanks, or click blank then click option'

A-

B'-'

C"-"

D_

Attempts:

3 left

💡 Hint

Common Mistakes

Using the dash without quotes causes an error.

Using single quotes may not work in Google Sheets formulas.

The delimiter must be a text string inside quotes. Using double quotes around the dash is the correct syntax.

4fill in blank

hard

Fill both blanks to split the text in D4 by semicolon and remove empty cells.

Google Sheets

=SPLIT(D4, [1], [2])

Drag options to blanks, or click blank then click option'

A";"

BTRUE

CFALSE

D,

Attempts:

3 left

💡 Hint

Common Mistakes

Using comma instead of semicolon as delimiter.

Setting the second argument to FALSE or omitting it, which keeps empty cells.

The delimiter is a semicolon inside quotes. The second argument TRUE tells SPLIT to remove empty cells from the result.

5fill in blank

hard

Fill all three blanks to split text in E5 by colon, keep empty cells, and split by each character.

Google Sheets

=SPLIT(E5, [1], [2], [3])

Drag options to blanks, or click blank then click option'

A":"

BFALSE

CTRUE

DTRUE

Attempts:

3 left

💡 Hint

Common Mistakes

Using TRUE for the second argument removes empty cells.

Not quoting the delimiter properly.

The delimiter is a colon inside quotes. The second argument FALSE keeps empty cells. The third argument TRUE splits by each character in the delimiter.