I have some several multiple line cells in column A on my worksheet with a lot of unwanted data. All cells contain an email address and a name which I want to put in separate columns.
If the cell contains "Name:" and "Email:", I want to put the Name in Column B and Email in Column C
Name: John Doe
Email: email@example.com <mailto:firstname.lastname@example.org>