Removing title from names :-
If we do need to remove common title (Mr., Mrs., Dr.) from a name . Then the following formula will be helpful:-
If we do need to remove common title (Mr., Mrs., Dr.) from a name . Then the following formula will be helpful:-
=IF(SUMPRODUCT(--ISNUMBER(FIND({"Mr.","Mrs.","Dr."},A3))),RIGHT(A3,LEN(A3)-FIND(".",A3)))
No comments:
Post a Comment