How to Convert Student Names to Emails
Learn how to convert student names into email addresses using Google Sheets by substituting spaces with either nothing or dots. This tutorial covers the use of the SUBSTITUTE function and ARRAYFORMULA for efficient email generation.
We have a list of students names, and we want to convert them to an email address with our school email. And what we're going to use is the entire name, but we're going to substitute space for either nothing or a dot, depending on what emails you need. I'll show you both ways. We're going to do equals, substitute. Text to search is going to be a two. I'm going to search for a space, and we're going to replace with, at this moment, nothing. I'll show you later how to replace it with a dot. And now to get the email address, we put an ampersand and put in the at school name dot edu. Now this could be autofilled all the way down, but we could also do this so that we don't have to continue copy and pasting if we add more. We can just put one formula here and it'll do it for all of them. Automate Emails Email Yourself a Cell from a Google Sheet, Every Day 43 Minutes of Google Sites and Google Sheets working together
So we're going to wrap this with array formula . And the only change we have to do is change a two to a two colon a. And now the entire column is email addresses . Now if we want to substitute the space with a dot, let's say, over in our substitute formula , instead of replacing with two quotation marks with nothing in there, just add a dot, and now everyone has a dot between their names. If you're looking to get more out of Google Sheets like these Google Sheet formula combinations, subscribe here to Better Sheets on YouTube. How to Merge Cells in Google Sheets Your First Formula in Google Sheets Better Email Form on Google Sites Remove Extra Spaces