...

Cut-and-pasted people data from "grad" 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(D40,"@cornell.edu")
• Column "H", Full name. Code:
  • =CONCATENATE(B40," ",C40)

====================

Cut-and-paste email addresses from NetID column (D) to Email address column (H).

...