Index

In Excel spreadsheet Index editor types the page numbers next to the students' name. Each page number in a separate cell. Put page numbers after the student's name in ascending order. ALL students in the school database in mid September are included. Check with Admissions to see if that's everyone. Past custom is not to include new students after that date. So there MUST be at least one photo of each student - either in mugs or camera shy. You can check this by ascertaining if each student has at least one page number next to his name.

Then follow these steps to move from Excel spreadsheet to text file (text flow) for InDesign. Same as text flow on mug shot page.

Open the **Excel** worksheet with students'/teachers' names. (one cell with first, one cell with last) Put cursor in new column, top row. Select Insert, Function, Text, Concatenate For Text 1 select first cell with first name. - Then click small up-arrow. For Text 2 - enter space For Text 3 - select first cell with last name. This is the formula where C1 through K1 contain the page numbers. There is a comma and space in between. =CONCATENATE(A1,", ",B1," ",C1,", ",D1,", ",E1,", ",F1,", ",G1,", ",H1,", ",I1,", ",J1,", ",K1) Copy formula down the complete column. Select this column and copy. Put cursor in new cell and go to Paste Special, Values Select this new column and copy. Open up **Word** and Paste. Select Table and Convert - Table to text - Save doc (name it "index text flow")
 * Use Find and Replace to delete extra spaces and commas in Word.**