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