#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
is there a spreadsheet for class lists? mesdot New Users to Excel 3 September 2nd 06 08:20 AM
Stuck on combining two lists with different column headers MrB1onde Excel Discussion (Misc queries) 1 August 7th 06 10:24 PM
Help with Lists... Corey Excel Discussion (Misc queries) 0 July 5th 06 08:39 PM
Counting Entries in two lists MarkN Excel Worksheet Functions 2 November 30th 05 08:15 AM


All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"