...
- 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","")
- =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
...