(Part of my administrative assistant series on Google Sheets.) The other task that can be labor intensive without a formula is joining fragments together into a single cell. I can actually remember spending a whole DAY once creating student accounts that followed a certain pattern so I could upload them for auto-account creation in an online system. This was for a single grade...and