Microsoft Office Tutorials and References
In Depth Information
Removing Titles from Names
Removing Titles from Names
If you have a list of names, you might need to remove titles (such as Mr., Ms., or Mrs.) from them.
You might want to perform this operation before you parse the name, as described in Tip 106.
You can use the following formula to remove three common titles (Mr., Ms., and Mrs.) from a
name; for example, if cell A1 contains Mr. Fred Mertz, the formula returns Fred Mertz:
=IF(OR(LEFT(A1,2)=”Mr”,LEFT(A1,3)=”Mrs”,LEFT(A1,2)=”Ms”),
RIGHT(A1,LEN(A1)-FIND(“ “,A1)),A1)
This formula tests for three conditions. If you need to test for more, just add arguments to the OR
function.
 
Search JabSto ::




Custom Search