Đang Thực Hiện

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 thêm: 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

Mã Dự Án: #1679505

Đã trao cho:

binaryromel

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

$5 USD / hour
(66 Đánh Giá)
5.7

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

Teloquence

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

$5 USD / hour
(210 Đánh Giá)
6.9
nagybatonyi

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 / hour
(53 Đánh Giá)
5.7
nikhil08

Hi, Expert here, Please check Inbox for details.

$5 USD / hour
(38 Đánh Giá)
5.6
mimirabb

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

$2 USD / hour
(47 Đánh Giá)
5.0
hemi

Please see more details on PMB. Thanks

$5 USD / hour
(21 Đánh Giá)
4.3
nagendraraja

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

$8 USD / hour
(11 Đánh Giá)
4.1
suresh7777

i am ready to work

$3 USD / hour
(0 Đánh Giá)
0.0
chinni646

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

$5 USD / hour
(0 Đánh Giá)
0.0