...
- Filter-select just "Grad" in Title column ("E").
- Add code to column "I" for all Grads:
- =SUBSTITUTE(DCell_NumberD2,"@cornell.edu","")
- Reminder: Replace the 2 in D2 with the right number!
- =SUBSTITUTE(DCell_NumberD2,"@cornell.edu","")
- Paste as "Values" into NetID column, "E".
...
- Filter-select all by "*Faculty" in Title column ("E).
- Column "G", Email address. Code:
- =CONCATENATE(D40D2,"@cornell.edu")
- Reminder: Replace the 2 in D2 with the right number!
- =CONCATENATE(D40D2,"@cornell.edu")
- Column "H", Full name. Code:
- =CONCATENATE(B40B2," ",C40)C2)
- Reminder: Replace the 2 in D2 with the right number!
- =CONCATENATE(B40B2," ",C40)C2)
====================
Cut-and-paste email addresses from NetID column (D) to Email address column (H).
...