TRIM and CLEAN in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to remove extra spaces from cell A1.

Excel

= [1](A1)

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

ATRIM

BCLEAN

CLEFT

DRIGHT

Attempts:

3 left

💡 Hint

Common Mistakes

Using CLEAN instead of TRIM removes non-printable characters but not extra spaces.

Using LEFT or RIGHT extracts parts of text, not spaces.

The TRIM function removes extra spaces from text, leaving only single spaces between words.

2fill in blank

medium

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

Excel

= [1](B2)

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

ALEN

BTRIM

CCLEAN

DSUBSTITUTE

Attempts:

3 left

💡 Hint

Common Mistakes

Using TRIM only removes extra spaces, not non-printable characters.

SUBSTITUTE replaces specific characters but needs you to specify them.

The CLEAN function removes non-printable characters from text, which helps clean data imported from other sources.

3fill in blank

hard

Fix the error in the formula to clean and trim text in cell C3.

Excel

= [1](TRIM(C3))

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

ALOWER

BUPPER

CTRIM

DCLEAN

Attempts:

3 left

💡 Hint

Common Mistakes

Using TRIM twice or in the wrong order.

Using UPPER or LOWER changes case but does not clean text.

The correct order is to first trim spaces, then clean non-printable characters. Here, CLEAN should wrap TRIM.

4fill in blank

hard

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

Excel

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

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

ACLEAN

BTRIM

CUPPER

DLOWER

Attempts:

3 left

💡 Hint

Common Mistakes

Reversing the order causes spaces to remain or cleaning to miss characters.

Using UPPER or LOWER instead of CLEAN or TRIM.

First trim spaces with TRIM, then remove non-printable characters with CLEAN.

5fill in blank

hard

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

Excel

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

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

AUPPER

BCLEAN

CTRIM

DLOWER

Attempts:

3 left

💡 Hint

Common Mistakes

Changing case before cleaning or trimming causes unexpected results.

Using LOWER instead of UPPER when uppercase is needed.

First trim spaces with TRIM, then clean non-printable characters with CLEAN, finally convert text to uppercase with UPPER.