Sheets AcademySheets Academy
Premium
Task #39

Last name and initials

The staff directory needs the last name and initials: “Smith, John Michael” → “Smith, J. M.”.

  1. Write a formula in B2.
  2. Fill it down to B7.
Task #39
Last name and initials

The staff directory needs the last name and initials: “Smith, John Michael” → “Smith, J. M.”.

  1. Write a formula in B2.
  2. Fill it down to B7.