Question: a work file gives first and last names of several...
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 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 file contains the fictitious addresses of some of our favorite people. Use text functions to extract each person’s name to one column and each person’s street address to another.