MCQs>Finance & Management>Excel>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?
Excel MCQs
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?
Answer
Correct Answer: =VALUE(LEFT(A3,4))
Explanation:
Note: This Question is unanswered, help us to find answer for this one