1.22.2021

Excel Tip: Extract Last Name






=RIGHT(A2,LEN(A2)-FIND("*",SUBSTITUTE(A2," ","*",LEN(A2)-LEN(SUBSTITUTE(A2," ","")))))

Comment: HT Link

No comments:

Post a Comment

Any anonymous comments with links will be rejected. Please do not comment off-topic