How to Convert Student Names to Emails
How to Create Student Email Addresses in Google Sheets
Learn how to convert a list of student names into email addresses using Google Sheets. This tutorial demonstrates the use of the SUBSTITUTE and ARRAYFORMULA functions to replace spaces with either nothing or a dot and auto-fill the emails for the entire column. Subscribe to Better Sheets on YouTube for more Google Sheets tips and tricks.
00:00 Introduction to Email Conversion
00:15 Using SUBSTITUTE Function
00:46 Creating Array Formulas
00:57 Adding Dots in Email Addresses
01:12 Subscribe for More Tips