Versions Compared

Old Version 28

changes.mady.by.user user-265f8

Saved on

compared with

New Version 29

changes.mady.by.user user-265f8

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...