1. Incorporate the imported data in the range B5:E10 as follows:
   1. Copy the Position data from the range J13:J18 and paste only the values in the range B5:B10.
   2. In cell C5, enter a formula using the PROPER function to capitalize the first letter in each word in the Specialty text in cell K13.
   3. Fill the range C6:C10 with the formula in cell C5 to list the specialties of the remaining team members.
   4. In cell D5, enter a formula using the LEFT function to insert the first 2 characters on the left of cell L13. Copy the formula in cell D5 to the range D6:D10.
   5. In cell E5, enter a formula using the RIGHT function to insert the last 2 characters on the right of cell M13. Copy the formula in cell E5 to the range E6:E10.

I NEED 5. ANSWERED

B Position Specialty D E Years Experience from 4 Name 5 6 7 8 9 9 10 11 F K L M H Performance Summary ($ millions) 4 5 6 7 8 9 10 11 12 EmployeeID 13 14 10 years 15 - FirstName 302 Jeff 346 Theresa 377 Victor 414 Heather 459 Claudia 511 Frank LastName Position Specialty Experience Birth Place Frye Portfolio Manager fund administration 12 years New York, NY Gao Research Analyst acquisition San Jose, CA Lattimer Investments business development 10 years Athens, OH Montgomery Relationship Manager asset management 8 years Wilton, CT Garcia Sales Manager technology 6 years Trenton, NJ Krause Research Analyst investments 5 years LaCrosse, WI 16 17 18 B Position Specialty D E Years Experience from 4 Name 5 6 7 8 9 9 10 11 F K L M H Performance Summary ($ millions) 4 5 6 7 8 9 10 11 12 EmployeeID 13 14 10 years 15 - FirstName 302 Jeff 346 Theresa 377 Victor 414 Heather 459 Claudia 511 Frank LastName Position Specialty Experience Birth Place Frye Portfolio Manager fund administration 12 years New York, NY Gao Research Analyst acquisition San Jose, CA Lattimer Investments business development 10 years Athens, OH Montgomery Relationship Manager asset management 8 years Wilton, CT Garcia Sales Manager technology 6 years Trenton, NJ Krause Research Analyst investments 5 years LaCrosse, WI 16 17 18