ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Class lists (https://www.excelbanter.com/excel-discussion-misc-queries/119804-class-lists.html)

Andmor

Class lists
 
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.

CLR

Class lists
 
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.



All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com