LEFT, RIGHT, MID extraction in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

Excel

=LEFT(A1, [1])

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

A1

B5

C3

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 returns an empty string.

Using 1 extracts only the first character.

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

2fill in blank

medium

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

Excel

=RIGHT(B2, [1])

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

A4

B1

C6

D2

Attempts:

3 left

💡 Hint

Common Mistakes

Using 2 extracts only two characters.

Using 6 may extract more characters than exist.

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

3fill in blank

hard

Fix the error in the MID formula to extract 5 characters starting from the 3rd character in cell C3.

Excel

=MID(C3, [1], 5)

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

A5

B3

C1

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 causes an error because positions start at 1.

Using 1 extracts from the first character, not the third.

The MID function needs the starting position as the second argument. To start at the 3rd character, use 3.

4fill in blank

hard

Fill both blanks to extract 4 characters starting from the 2nd character in cell D4 using MID.

Excel

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

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

A2

B3

C4

D5

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the start position and length.

Using 5 extracts too many characters.

The MID function's second argument is the start position (2), and the third argument is the number of characters to extract (4).

5fill in blank

hard

Fill all three blanks to extract 3 characters starting from position 4 using MID and the first character using LEFT from cell E5.

Excel

=MID(E5, [1], [2]) & LEFT(E5, [3])

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

A4

B3

C2

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up the start position and length.

Using 2 for LEFT extracts too many characters.

The MID function starts at position 4 and extracts 3 characters. The LEFT function extracts 1 character from the start.