Hi Anne,
Great question – this formula is relatively easy. Here is what to type into the cell where you want the email to appear:
=lower(a2&left(b2,1)&“@stmarysrotorua.school.nz”
Notes:
- 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,
Rob