Microsoft Office Tutorials and References
In Depth Information
You can access the workbook for removing middle names and initials at this topic's
website. The filename is no middle name.xlsx.
Figure 21-2: The goal is to remove the middle name or middle initial from each name.
Figure 21-3: Removing the middle names and initials requires six intermediate formulas.
Table 21-2: Intermediate Formulas in the First Row of Sheet1 in Figure 21-3
Cell
Intermediate Formula
What It Does
B1
=TRIM(A1)
Removes excess spaces
Search JabSto ::




Custom Search