Requirements: 1. Use the =Concat function to take column A and B and combine them with a space between First Name and Last Name to give Full Name in column D. Widen column D to show all full names. 2. Use the Data --> Text to Columns command from the menu to populate column E with the Username. The Username is the first part of the email address without the @upei.ca. Hint - you may have to copy column C to column E before you do the Test to Columns command. Once you have the Username column populated you can delete Column F. 3. Sort the list by Last Name and then by First Name within the same Sort at the same time. Sort by alphabetic order A-Z