A work file 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 employees first name by the employees last name and add @microsoft.com to the end. Use text functions to efficiently create the email addresses.

A file contains the fictitious addresses of some of our favorite people. Use text functions to extract each persons name to one column and each persons street address to another.

USE EXCEL