Hi All,
I've been given a messy excel sheet with email addresses. With messy I mean some rows have an "email address", others have "first name last name <email address>", others have well I will probably ask about those later, in the mean time. I want to get all the email addresses only from the "first name last name <email address>", in other words, I want to pick out anything between the < >, I am hoping there's a way to do this other than manually. Does anyone have any suggestions?
Your help is appreciated!
Mac
I've been given a messy excel sheet with email addresses. With messy I mean some rows have an "email address", others have "first name last name <email address>", others have well I will probably ask about those later, in the mean time. I want to get all the email addresses only from the "first name last name <email address>", in other words, I want to pick out anything between the < >, I am hoping there's a way to do this other than manually. Does anyone have any suggestions?
Your help is appreciated!
Mac