The file named Emailproblem.xlsx gives first and last names of several new Microsoft employees. To create an email address for each employee, you need to follow the first letter of the employee’s first name by the employee’s last name and add @microsoft.com to the end. Use text functions to efficiently create the email addresses.

A 1 Calista Flockhart 2 Peyton Manning 3 Jessica Simpson 4 Britney Spears 5 Vince Vaughn 6 Owen Wilson 7 Dirk Nowitzki 8 Duane Wade 9 Albert Puhols 10 11 12 < B 11 11 C D