combining last name first name mid initial

  • Thread starter Thread starter JimTeacher
  • Start date Start date
J

JimTeacher

I'm a teacher who is responsible for breaking down a file with 2000
students and 200 teachers in 5+ classes each into individual department
files.

There are three NAME cells - Last name, First name, Middle initial in
each row.

Row 1: Cell 1 - Jones; Cell 2 - Mary; Cell 3 - Z.

I need to have those three cells for each student combined into one
cell with a formula so that I can cut and paste a section of students
into another excel file so that textbooks can be scanned.

Row 1: Cell 1 - Jones, Mary Z

We've done it in the past, but we've lost the formula.

Thanks for saving my life!!! :)

Jim
 
I'm a teacher who is responsible for breaking down a file with 2000
students and 200 teachers in 5+ classes each into individual
department files.

There are three NAME cells - Last name, First name, Middle initial in
each row.

Row 1: Cell 1 - Jones; Cell 2 - Mary; Cell 3 - Z.

I need to have those three cells for each student combined into one
cell with a formula so that I can cut and paste a section of students
into another excel file so that textbooks can be scanned.

Row 1: Cell 1 - Jones, Mary Z

We've done it in the past, but we've lost the formula.

Thanks for saving my life!!! :)

Jim
Click to expand...

Concatenate. Concatenate A1 " " B1 " "C1 or similar.
 
Back
Top