Elance Exams Answers PDF file

-- PDF FILE --
Download PDF file of elance Zoho Creator Exam Answers
elance-zoho-creator-exam.pdf

Column A lists a long string (example:A3= 1234Smith1740.434.21) where the first four digits are the employee number. What formula in B3 will extract only the employee number from the string in cell A3?

=VALUE(LEFT(A3,4))
=VALUE(TEXT(A3,4))
=RIGHT(A3,4)
=IF(A3="Ted","1234","")
Top
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon