...
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).
...