Reply To: Student email addresses

Home Forums Google Sheets & Forms Student email addresses Reply To: Student email addresses

Rob Clarke

Hi Anne,

Great question – this formula is relatively easy. Here is what to type into the cell where you want the email to appear:



  • the LOWER function makes everything lower case within the enclosed brackets ().
  • A2 is the first name of the student.
  • B2 is the last name of the student.
  • the LEFT(b1,1) function identifies the characters from the left to grab from that cell, where the: “,1” makes it one character.
  • the ampersand (&) tells the formula to join something else on, in this case the text is enclosed in “double quotation” marks.

Done! Go well and have a great week ahead,


Skip to toolbar