Homework 10: Text and Time

• Provide practice with Date and text functions.

• Start by downloading this file.
  • This is a completely fabricated data set.
  • It consists of a series of contacts and dates of contact.
  • Unfortunately the contacts are not well formatted.
• Please be advised, you must perform the following using text and date functions as instructed. No credit will be given for alternative methods.
  • Using the find function, compute the location of the word "email" in the file. Place this in column B.
  • Using the left function, compute the person's name in column C
  • Using the find function, compute the location of the @ in column D
  • Using the mid function, compute the user name in column E (between email and @)
  • Using the month function compute the month of the year (number) in column G
  • Using the day function, compute the day of the month in column H
  • Using formatting and the weekday function, compute the day of the week in column I
  • 
• Submit your homework in the D2L assignment folder Homework 10