> > >

Excel MCQs

If cell A2 has a full name (Fristname, Middle Initial and Lastname) like "Karen E. McRich" which of the following formula will extract the lastname?

=RIGHT(A2, LEN(A2) - FIND(" ", A2, FIND(" ", A2) +1))

=MID(A2, LEN(A2) - FIND(" ", A2, FIND(" ", A2) +1))

=FIND(" ", A2, FIND(" ",A2) + 1)

=RIGHT(A2, FIND(".", A2) - 1, 1)

Answer

Correct Answer: =RIGHT(A2, LEN(A2) - FIND(" ", A2, FIND(" ", A2) +1))

Explanation:

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

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it