Concatenate using an array formula to result in last name.firstname

by Anil Banatwala   Last Updated March 19, 2019 14:03 PM

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?



Answers 1


  • perhaps try it like this:

    =ARRAYFORMULA(IF(LEN(A:A), B:B&"."&A:A, ))

    0

user0
user0
March 19, 2019 13:34 PM

Related Questions


Updated April 13, 2019 13:03 PM

Updated April 13, 2019 13:03 PM

Updated April 18, 2019 21:03 PM

Updated May 08, 2019 00:03 AM

Updated May 08, 2019 01:03 AM