Not syncing A B C D E 1 Email First Last # Concatenate 2 pdangelo1@company.ca P dangelo 1 pdangelo1@company.ca 3 dgoggin2@company.ca d goggin 2 dgoggin2@company.ca 4 bluu2@company.ca luu 12 bluu2@company.ca 5 cprow8@company.ca C prow 8 cprow8@company.ca 6 ddecato2@company.ca d decato 2 ddecato2@company.ca 7 ssilguero9@company.ca silguero 9 ssilguero9@company.ca 8 sjacobi1@company.ca jacobi sjacobi1@company.ca 9 tpalmatier5@company.ca palmatier 15 tpalmatier5@company.ca 10 efoust6@company.ca foust 6 efoust6@company.ca 11 ulomonaco 7@company.ca u lomonaco 7 ulomonaco7@company.ca Question 4: Type in a LEFT() function that could be typed in cell B2 then copied down to determine the first initial of the email address in cell A2. Do not use any other functions in your answer. Start with =LEFT( and finish with ) Question 5: Type in a MID() function that also uses a LEN() function that could be typed in cell C2 then copied down to determine the last name of the email address in cell A2. Hint: The length of the last name will vary, but you can use the total length and also manually count how many characters on the right you won't need Do not use any other functions in your answer, Start with =MID( and finish with ) Question 6: Type in a LEFT() function that also uses a RIGHT() function that could be typed in cell D2 then copied down to determine the single digit of the email address in cell A2. Hint: Manually count how many characters on the right you won't need. Do not use any other functions in your answer. Start with =LEFT( and finish with )