Recall & Review
beginner
What does the LEFT function do in Excel?
The LEFT function extracts a specified number of characters from the start (left side) of a text string.
Click to reveal answer
beginner
How do you extract the last 3 characters from a text string in Excel?
Use the RIGHT function with 3 as the number of characters, like this: RIGHT(text, 3).
Click to reveal answer
beginner
Explain the MID function in Excel.
MID extracts characters from the middle of a text string. You specify the start position and how many characters to take, like MID(text, start_num, num_chars).
Click to reveal answer
beginner
What will the formula =LEFT("Hello World", 5) return?
It returns "Hello" because it takes the first 5 characters from the left of the text "Hello World".
Click to reveal answer
beginner
If cell A1 contains "Spreadsheet", what does =MID(A1, 6, 5) return?
It returns "sheet" because it starts at the 6th character and takes 5 characters from "Spreadsheet".
Click to reveal answer
Which function extracts characters from the end of a text string?
✗ Incorrect
RIGHT extracts characters from the end (right side) of a text string.
What does =LEFT("Excel", 2) return?
✗ Incorrect
LEFT("Excel", 2) returns the first two characters: "Ex".
How do you extract 4 characters starting from the 3rd character in a text string?
✗ Incorrect
MID(text, 3, 4) extracts 4 characters starting at position 3.
If A1 contains "Data", what does =RIGHT(A1, 2) return?
✗ Incorrect
RIGHT(A1, 2) returns the last two characters: "ta".
Which formula extracts the first character of a text string?
✗ Incorrect
LEFT(text, 1) extracts the first character from the left.
Describe how to use LEFT, RIGHT, and MID functions to extract parts of a text string in Excel.
Think about where you want to start extracting characters: beginning, end, or middle.
You got /3 concepts.
Give an example of a situation where you would use the MID function instead of LEFT or RIGHT.
Consider extracting a part that is not at the start or end.
You got /3 concepts.