Fill in a Spreadsheet with Data - Separate, TRIM, PROPER, LOWER -- 2

In each file I want you to 1 - Separate the Prefix, First Name, Middle Name, Last Name. Some files are done correct others are not. 2 - Make everything Proper except email address and websites, I do not want all Capital Letters. 3 - Make email address all Lower 4 - Use TRIM Function for every column so there is no space in the front or at the end. 5 - Leave each file name the same