Microsoft Office Tutorials and References
In Depth Information
Figure 5-7: This worksheet uses formulas to extract the first name, middle name (or initial), and last name from
a list of names in column A.
Removing titles from names
You can use the formula that follows to remove four common titles (Mr., Dr., Ms., and Mrs.) from a name. For
example, if cell A1 contains Mr. Fred Munster, the following formula would return Fred Munster.