I have an Excel spreadsheet with 2 columns. The first column is "NAME" and the second column is "EMAIL"
1. The data in the NAMES column include 3 or 4 names separated by spaces; 1st, 2nd, 3rd and/or 4th name. I would like someone to create a FIRST NAME and LAST NAME, 2 columns. Then, write a script that will take the 1st and 2nd name and put it into the FIRST NAME column. Then, place the 3rd and/or 4th name and put it into the LAST NAME column. (See sample Excel file attached).
2. The EMAIL column has email addresses. I would like someone to write a script that will drop the @ and everything to the left of it and replace it with "http://www." (See sample file attached).
There are approximately 10,000 records in the spreadsheet. I need it done QUICK and CHEEP.