Split text to columns in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to split the full name in A1 into separate columns using a space delimiter.

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 comma instead of a space for name splitting.

Forgetting to wrap the delimiter in quotes.

Full names are separated by spaces, so using " " as the delimiter splits first and last names into separate columns.

2fill in blank

medium

Complete the formula to split a date string like '2024-01-15' in B2 into year, month, and day columns.

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 a slash when the date uses dashes.

Using a space delimiter for dash-separated dates.

The date format uses dashes as separators, so "-" splits the date into year, month, and day columns.

3fill in blank

hard

Fix the formula to split a CSV-style value in C3 like 'apple,banana,cherry' into separate columns.

Google Sheets

=SPLIT([1], ",")

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

AC3

B"C3"

CC3:C10

D$C$3

Attempts:

3 left

💡 Hint

Common Mistakes

Wrapping the cell reference in quotes turns it into a text string.

Using a range instead of a single cell for SPLIT.

The first argument of SPLIT must be a cell reference without quotes. Using C3 directly references the cell containing the text to split.

4fill in blank

hard

Fill both blanks to split text in D4 by pipe character and remove empty results.

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 FALSE keeps empty cells in the output.

Using comma instead of pipe as the delimiter.

The pipe character | is the delimiter. Setting the second argument to TRUE removes any empty strings from the result.

5fill in blank

hard

Fill all three blanks to split text in E5 by tab character, keep empty cells, and treat the delimiter as a whole string.

Google Sheets

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

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

ACHAR(9)

BFALSE

CTRUE

DFALSE

Attempts:

3 left

💡 Hint

Common Mistakes

Trying to type a tab character directly instead of using CHAR(9).

Setting the third argument to TRUE splits by each character separately.

CHAR(9) represents the tab character. FALSE for the second argument keeps empty cells. FALSE for the third argument treats the delimiter as a whole string rather than splitting by each character.