f$.$ In cell I$1,$ type PositionDepartment In cell I$2,$ use the LEFT and FIND functions to extract the department from column F$.$ Notice that the column F values have the position department, a comma, and then the salary code. Use th PROPER function to ensure that the departments are the appropriate case. Use the TRIM function to remove any nonprintable characters and spaces.. Resize the columns as needed to fit the contents.

g$.$ In cell J$1,$ type SalaryCode In cell J$2,$ use the RIGHT, LEN, and FIND functions to extract the SalaryCode from column F$.$ Use the TRIM function to remove any nonprintable characters and spaces. Resize the columns as needed fit the contents.