Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Making an Email List from a spreadsheet list

Making an Email List from a spreadsheet list

I love it when I see people getting excited about Excel commands.

Robert Madden
mrmadden77Robert Madden

The answer to life’s problems (at least for today): =CONCATENATE(B2, LEFT(A2,2), RIGHT(F2,4))

 

One of my favorite things to teach in an advanced Excel class is the concept of Concatenate, but who can remember that word or how to spell it? Luckily there is an easier way to join together data from one cell and another.

Here is a tutorial on how to create an email list from a list of names.
I copied and pasted a bunch of names off of the internet, some early colonists.
I am using Google Spreadsheet

Now if you are typing this list yourself and can put first and last name into different columns that is best.  If you are using EXCEL you can use data to columns in the ribbon to separate the names into separate columns.

In Google Spreadsheet I need to use the function =Split(cell,” “) where I put a space in between quotations to tell the spreadsheet to split the cells up at the space.  If you have commas it would look like =split(cell,”, “)
Note the space after the comma since likely you have last name comma SPACE first name.

Drag that formula down the list

There are a couple of functions you may want to know.  =LEFT(cell,#) will give you the number of characters from the left side of the string that you designate.  For example if you have keeler in cell A1 and in cell B1 you type =LEFT(A1,3) it will return kee… the left 3 characters.

=RIGHT(Cell,#) will do the same thing but from the right side.  So if in cell A1 you have keeler and in cell B1 you type =RIGHT(A1,3) you would get ler.

If you want your text from the middle of a text string you can use =mid(cell,starting character number, ending character number).
So if I have the word complementary in cell A1 and then in cell B1 type =mid(A1,7,10) I would get ment returned.

To join two cells together you use the ampersand symbol. (&)

So lets say for my email list the pattern is the first letter of the first name, joined with the last name joined with @mydistrict.k12.ca.us

Then my formula is
=left(cell with first name,1)&cell with last name&”@mydistrict.k12.ca.us”

Remember all text strings need to be in quotations.

Drag that formula down the sheet and you have a list of email addresses you can now copy and paste into your TO field of your email.

Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

1 thought on “Making an Email List from a spreadsheet list

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d