LEFT, RIGHT, MID in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to extract the first 3 characters from cell A1.

Google Sheets

=LEFT(A1, [1])

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

A2

B5

C4

D3

Attempts:

3 left

💡 Hint

Common Mistakes

Using a number larger than the text length causes no error but extracts extra characters.

Confusing LEFT with RIGHT or MID functions.

The LEFT function extracts characters from the start of the text. Using 3 extracts the first 3 characters.

2fill in blank

medium

Complete the formula to extract the last 4 characters from cell B2.

Google Sheets

=RIGHT(B2, [1])

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

A3

B4

C5

D6

Attempts:

3 left

💡 Hint

Common Mistakes

Using LEFT instead of RIGHT.

Using a wrong number of characters.

The RIGHT function extracts characters from the end of the text. Using 4 extracts the last 4 characters.

3fill in blank

hard

Fix the error in the formula to extract 5 characters from the middle of cell C3 starting at position 2.

Google Sheets

=MID(C3, [1], 5)

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

A2

B1

C3

D5

Attempts:

3 left

💡 Hint

Common Mistakes

Using 1 instead of 2 for start position.

Confusing the order of arguments.

The MID function syntax is MID(text, start_position, number_of_characters). To start at position 2, use 2.

4fill in blank

hard

Fill both blanks to extract 4 characters from cell D4 starting at position 3.

Google Sheets

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

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

A3

B4

C5

D2

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping start position and number of characters.

Using wrong numbers for either blank.

The MID function needs the start position and the number of characters. Start at 3 and extract 4 characters.

5fill in blank

hard

Fill all three blanks to extract the first 2 characters from cell E5, then the last 3 characters from cell F5, and finally 4 characters from cell G5 starting at position 2.

Google Sheets

=LEFT(E5, [1]) & RIGHT(F5, [2]) & MID(G5, [3], 4)

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

A2

B3

D4

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up numbers for LEFT and RIGHT.

Using wrong start position for MID.

LEFT(E5,2) extracts first 2 chars, RIGHT(F5,3) extracts last 3 chars, MID(G5,2,4) extracts 4 chars starting at position 2.