You work with the Student Education Trust , which allows you to demonstrate your expertise with Excel . The trust is sponsoring an auction , and you have received a list of all donors who have contributed to this auction . The list was pulled from their database as a comma-separated text file . You have been asked to create a letter that will go out to each of the contributors that will accept their donation . Tickets to the event will be enclosed . The letter requires that you provide the following pieces of information .
• Full name and address
• First name
• Donated item
• Value
• Number of tickets requested STEP 1 : Import Text File Into a Spreadsheet and Clean up Data
A . Download the text file : Week4 _ iLab _ MailingData _ Student . txt . To complete the download , right click on the file name and select Save Link As . The file will save to your local drive .
B . Open a new Excel file and import only the data from the txt file you will need for your letter ( i . e ., excluding unnecessary columns ).
C . Separate the first and last names into two columns so that you may use the first name in a Mail Merge . Make sure the fields are named LastName and FirstName .