MCQs > Finance & Management > Excel > Cell A1 contains the text string 'BA1740'. The formula to extract the last four characters as a value in A1 is:

Excel MCQs

Cell A1 contains the text string 'BA1740'. The formula to extract the last four characters as a value in A1 is:

Answer

Correct Answer: =VALUE(RIGHT(A1,4))

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

Excel Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it