Find specific data and put in in a another cell.
Posted on 2013-12-29
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>