Separate data in 1 column into 2 column

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.

Compétences : Programmation C, Excel, Visual Basic

en voir plus : programming in excel, programming in basic, excel data programming, separate last names excel, second last name, data visual, data in, Column, sample visual basic excel, write data excel spreadsheet, replace visual basic excel, separate columns, quick basic data, http www data excel, column data excel, sample names addresses excel, column excel, separate, separate addresses excel, separate data excel rows column columns, data programming excel, separate excel, cheep script, visual basic script email, visual basic programming excel

Concernant l'employeur :
( 6 commentaires ) Cincinnati, United States

Nº du projet : #1679505

Décerné à:


##### Excel expert here! Please check PM. #####

$5 USD / heure
(66 Commentaires)

9 freelance font une offre moyenne de $5/heure pour ce travail


Consider it done. Check your PM for my bid details.

$5 USD / heure
(210 Commentaires)

I'll complete it in 4 hours. My bid includes also the VBA script for future repetitive use if you need it. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. R Plus

$8 USD / heure
(53 Commentaires)

Hi, Expert here, Please check Inbox for details.

$5 USD / heure
(38 Commentaires)

I am ready to Separate data in 1 column into 2 column. Please check PM for details. Thank You!

$2 USD / heure
(47 Commentaires)

Please see more details on PMB. Thanks

$5 USD / heure
(21 Commentaires)

Dear Sir, We are ready to start and fulfill your requirement. Please check your inbox for details. Regards Rajaa

$8 USD / heure
(11 Commentaires)

i am ready to work

$3 USD / heure
(0 Commentaires)

Hi, I have experience in this. Please check pm. Thanks

$5 USD / heure
(0 Commentaires)