Skip to main content
Web Applications

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
added 2 characters in body; edited tags
Source Link
user0
user0
  • 27.1k
  • 10
  • 53
  • 78

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.johngeorgeharrysmithjohnsonjackson.johngeorgeharry. What am I doing wrong?

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?

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?

added 12 characters in body
Source Link
serenesat
serenesat
  • 10k
  • 30
  • 33
  • 50

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

I used =ARRAYFORMULA(CONCATENATE($B$52:$B,".",$B$52:$C)),

=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?

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?

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?

Source Link
Anil Banatwala
Anil Banatwala
  • 13
  • 1
  • 4

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

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?