Need help on this question using excel.

EMPLOYEE EMAIL ADDRESSES - TEXT FUNCTIONS 3 Your firm Blue Waves just hired several new employees. You are given their first and last names so you can create e-mail addresses for them. (1). To create an email address for each of the new employees, you are to (2). Use Excel Text to Column function to quickly (3). Make a name list with use the first letter of the employee's first name and the last name, and add separate the employees' first names from their last employees' last name and first @bluewave.com to the end. Use Excel text functions to efficiently create names in two columns. name to read "last name, first the email addresses. name". FULL NAME SPACE Length email address FULL NAME FIRST NAME LAST NAME FULL NAME Catherine Fleharty 10 18 Catherine Fleharty Peyton Mann 7 11 Peyton Mann Jessica Slate 8 13 Jessica Slate Beatrice Sparrish 9 17 Beatrice Sparrish Vincent Vamm 8 12 Vincent Vamm Oliver Wilson 7 13 Oliver Wilson Devon Nowich 6 12 Devon Nowich David Weston 12 David Weston Alan Puthony 5 12 Alan Puthony