added your last name to the beginning of the filename. The first column displays the name of the college or school (such as 5 ART or BUSINESS) associated with each. You want to assign a three- character code for each college and use that code to attach to existing donor IDs to create a unique field. In cell B8, insert the LEFT function to extract the first three characters from the college name in cell A8. Copy the function to the range B9:B35. You now want to combine the college ID and donor ID. 5 In cell D8, insert the CONCAT function to combine the college ID in cell B8 with the donor ID in cell C8 with a hyphen between the two text strings. Copy the function to the range D9:D35. In cell J8, insert a text function that displays the college name from cell 5 A8 with just the first letter capitalized, such as Engineering. Copy the function to the range J9:J35. The Full Name column displays last and first names of the donors. You 5 want to display last names only in a separate column. In cell F8, type Schneider and use Flash Fill to fill in the last names for the donors in the range F9:F35. The Address column contains street addresses, city names, and state 10 abbreviations. To manage the address list better, you will separate the data into three columns. Select the addresses in the range G8:G35 and convert the text to