I am trying to enter emails which all have the exact same text after the @ sign in excel so that part is not necessary to type each time i: *****************@crimson.ua.edu. I only want the person entering data to enter the individual part of the email that come prior to the @ sign.
I tried formatting this way and it does not work:
Format Cells >Custom Format> and typed: ###########@"crimson.ua.edu"
Bookmarks