...

Copy previous "master" list as a template for the new master list.

Use convention

...

"CCBpeople__YYYYMM"

This is now the current, date-stamped, people's "master" list.

...

• 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!
• Paste as "Values" into NetID column, "E".

Cut-and-pasted people data from "

...

staff" spreadsheet into "master" spreadsheet (columns A-F => A-F)

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

• Filter-select all by "*Faculty" in Title column ("E).
• Column "G", Email address. Code:
  • =CONCATENATE(D2,"@cornell.edu")
    • Reminder: Replace the 2 in D2 with the right number!
• Column "H", Full name. Code:
  • =CONCATENATE(B2," ",C2)
    • Reminder: Replace the 2 in D2 with the right number!