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: firstname.lastname@example.org <mailto:email@example.com>