...

• Insert column "C".
• Header is "Chair, type"
• Add code to first blank column, at end ("H"):
  • =IF(ISBLANK(A2),"No Chair specified",CONCATENATE(A2,", ",B2))
• CutCopy-and-paste results into "C" as "Values" only., then delete column H
  • Can't use cut, since Paste won't allow "Values" paste off a cut

Cut-and-pasted people data from "grad" spreadsheet into "master" spreadsheet (C-G => A-E)

...

• Filter-select just "Grad" in Title column ("E").
• Add code to column "I" for all Grads:
  • =SUBSTITUTE(D2,"@cornell.edu","")
    • Reminder: Replace the 2 in D2 with the right number!
    • Some of the addresses have leading spaces. To strip them, use this formula instead:
      • =SUBSTITUTE(SUBSTITUTE(D2," ",""),"@cornell.edu","")
• Paste as "Values" into NetID column, "E".

Rearrange columns in staff spreadsheet to match master

• The staff spreadsheet should have its columns rearranged to match the master spreadsheet
  • A -> Supervisor
  • B -> FirstName
  • C -> LastName
  • D -> NetID
  • E -> title
  • F -> CampusAddress

Cut-and-pasted people data from "staff" spreadsheet into "master" spreadsheet (columns A-F =>

...

D-

...

I)

In "master", fill out email address and full name columns

...