Which Function Returns the Leftmost Five Characters in Excel?
Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> Excel Quiz >> Which Function Returns the Leftmost Five Characters in Excel?
Question
Which function returns the leftmost five characters in Excel?- =TRIM(B3,5)
- =RIGHT(B3,5)
- =MID(B3,5)
- =LEFT(B3,5)
- =FIRST(B3,5)
Answer
D. =LEFT(B3,5)Explanation
Take a look at the screenshot below.As you can see there, the LEFT function can return the leftmost five characters of data in Excel. As the functions in other answer choices cannot do the same, the correct answer here should be D. Here are some examples of what we can call a range in excel.
Go back to the Compute Expert's excel quiz page