(Part of my administrative assistant series on Google Sheets.) There are some formulas that are well worth knowing when you are working with student data. For instance, the number of times that you have a CSV download which has the name in one cell, rather than divided into one cell for the first name and one for the last name, has frustrated me and many others I know time and again.