TRIM and CLEAN in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to remove extra spaces from cell A1.

Google Sheets

=TRIM([1])

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

ATRIM(A1)

BA1

CB1

D" A1 "

Attempts:

3 left

💡 Hint

Common Mistakes

Putting quotes around the cell reference like "A1" which treats it as text.

Using TRIM inside TRIM which is unnecessary here.

The TRIM function removes extra spaces from the text in cell A1.

2fill in blank

medium

Complete the formula to remove non-printable characters from cell B2.

Google Sheets

=CLEAN([1])

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

AA2

BCLEAN(B2)

C"B2"

DB2

Attempts:

3 left

💡 Hint

Common Mistakes

Using quotes around the cell reference, which makes it a text string.

Using the wrong cell reference.

The CLEAN function removes non-printable characters from the text in cell B2.

3fill in blank

hard

Fix the error in this formula that tries to clean and trim cell C3.

Google Sheets

=TRIM(CLEAN([1]))

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

A"C3"

BTRIM(C3)

CC3

DCLEAN(C3)

Attempts:

3 left

💡 Hint

Common Mistakes

Putting quotes around C3 which makes it text, not a cell reference.

Using TRIM or CLEAN incorrectly inside the formula.

The formula needs the cell reference C3 without quotes inside CLEAN, then TRIM removes extra spaces.

4fill in blank

hard

Fill both blanks to create a formula that cleans and trims text in D4.

Google Sheets

=TRIM([1]([2]))

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

ACLEAN

BD4

CA4

DTRIM

Attempts:

3 left

💡 Hint

Common Mistakes

Using TRIM inside TRIM which is redundant.

Using the wrong cell reference.

The CLEAN function removes non-printable characters from D4, then TRIM removes extra spaces.

5fill in blank

hard

Fill all three blanks to create a formula that trims, cleans, and converts text in E5 to uppercase.

Google Sheets

=UPPER([1]([2]([3])))

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

ATRIM

BE5

CCLEAN

DLOWER

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing the order of TRIM and CLEAN.

Using LOWER instead of UPPER.

Putting quotes around the cell reference.

The formula cleans E5, trims spaces, then converts the result to uppercase.