Import Text You need to import airline data (airline names, codes, and URLs) from a tab-delimited…

Import Text

You need to import airline data (airline names, codes, and URLs) from a tab-delimited file created by one of your colleagues. In addition, you need to separate the airline name from its code.

a. Open the tab-delimited file e09c1airlines.txt into Excel. Do not create a connection to the original data source. Use the tab character as a delimiter. Deselect all other delimiters. Save the data as e09c1flightdata_ LastnameFirstname in Excel Workbook format.

b. Insert a new column between the two existing columns, and then separate the data in the Airline-Code column into two columns—Airline and Code—using the hyphen.

c. Adjust column widths. Apply bold; Aqua, Accent 5, Lighter 80% fill color; and Aqua, Accent 5, Darker 50% font color to the column labels.

d. Rename the worksheet Airlines.