In D1 put this and copy down.........

=C1&" "&B1

Vaya con Dios,
Chuck, CABGx3



"Andmor" wrote:

I'm teaching 17 classes and need to update all my class lists. Instead of
updating the list for each assessment i have I want to create a master list
to populate the rest. I currently have all the students names in A in this
format Smith, John then because I needed to seperate the names in B I have
Smith and C I have John. Now I need some lists with the students names as
follows John Smith. Can anyone help.

--
A.