MCQs > Finance & Management > Excel > Which of the the following formulas will get the Last Name from name?

Excel MCQs

Which of the the following formulas will get the Last Name from name?

Answer

Correct Answer: =RIGHT(name,LEN(name)-FIND("*",SUBSTITUTE(name," ","*",LEN(name)-LEN(SUBSTITUTE(name," ","")))))

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