so Im trying to make a formula for a line of code to make an email address, using the First letter of the first name, add the last name, then the student Id then the @email.com
Code
A2 || Adam || Baum || 233413 || Baum, Adam || =MID(a2, 1, 1) + a3 + a4 + text("@email.com")
im doing it wrong but im not too too sure what I'm doing.