Fortunately, Excel has created TEXTBEFORE and TEXTAFTER to make ... name from a list of emails. See below for the dataset we will use: Note the delimiter here is the at symbol (@), and the username is ...