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

---
Message posted from http://www.ExcelForum.com/