Which function returns the leftmost five characters in cell A1?

  • =FIND(A1,1,5)
  • =SEARCH(A1,5)
  • =LEFT(A1,5)
  • =A1-RIGHT(A1,LEN(A1)-5)

The correct answer is:

  • =LEFT(A1,5)

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers