combining last name first name mid initial

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
 
G

Gordon

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top