We have a form that asks for the students first name and last name. I am trying to using concatenate and an array formula to display "Lastname.Firstname". I used =ARRAYFORMULA(CONCATENATE($B$52:$B,".",$B$52:$C)), but it displays all the last name, a period, then all the first names - looking like this smithjohnsonjackson.johngeorgeharry. What am I doing wrong?