BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 29

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.