Which function returns the leftmost five characters in cell A1?
=LEFT(A1,5)
=SEARCH(A1,5)
=FIND(A1,1,5)
=A1-RIGHT(A1,LEN(A1)-5)