Question: Which function returns the leftmost five characters in cell A1?

1. =FIND(A1,1,5)
2. =SEARCH(A1,5)
3. =LEFT(A1,5)
4. =A1-RIGHT(A1,LEN(A1)-5)

Answer: The correct answer of the above question is Option C:=LEFT(A1,5)