The names should also be proper cased.

In column C$,$ use the appropriate text function to convert the data in column B into proper case. Resize the column as needed to fit the contents$\mathrm{.}27$In cell D$2,$ use the appropriate text function to remove any extra spaces before or after as well as between the names in column C$.$ Resize the column as needed to fit the contents$\mathrm{.}28$In column E$,$ use the appropriate text function to return the position of the space character located in the data in column D$.$ Resize the column as needed to fit the contents.

$2\mathrm{.}49$In column F$,$ use the appropriate text function to extract only the last name from column D$.$ Use the number in column E as the relative starting point for the number of characters needed to extract only the last name from the left side of the data in column D $($no extra spaces$).$ Resize the column as needed to fit the contents.

$2\mathrm{.}410$In column G$,$ use the appropriate text functions to extract only the first name and middle initial from column D$.$ Use the value in column E as part of the calculation to determine the number of characters needed to extract only the first name and middle initial from the right side of the data in column D$.$ Resize the column as needed to fit the contents.

$3\mathrm{.}211$In column H$,$ use the ampersand symbol $($&$)$ to concatenate the first name and middle initial in column G and the last name in column F with a space in between. Resize the column as needed to fit the contents.