In the cell range C2:C17, insert a text function to clear any nonprinting characters and extra spaces from the names in column A. In cell D1, type FirstName as the column heading. In the cell range D2:D17, insert text functions to display only the first name from the right side of the clean names in column C. The names should be displayed in proper case