Đã hoàn thành

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.

Kĩ năng: Lập trình C, Excel, Visual Basic

Xem nhiều hơn: 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

Về Bên Thuê:
( 6 nhận xét ) Cincinnati, United States

ID dự án: #1679505

Được trao cho:


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

$5 USD / giờ
(66 Đánh Giá)

9 freelancer đang chào giá trung bình $5/giờ cho công việc này


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

$5 USD / giờ
(210 Nhận xét)

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 Thêm

$8 USD / giờ
(53 Nhận xét)

Hi, Expert here, Please check Inbox for details.

$5 USD / giờ
(38 Nhận xét)

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

$2 USD / giờ
(47 Nhận xét)

Please see more details on PMB. Thanks

$5 USD / giờ
(21 Nhận xét)

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

$8 USD / giờ
(11 Nhận xét)

i am ready to work

$3 USD / giờ
(0 Nhận xét)

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

$5 USD / giờ
(0 Nhận xét)