Completed

Excel Data extraction automation

Hi,

We would like to:

1. Extract first, middle, last names from a MS excel cell and paste it in to 1. first name cell and 2. last name cell.

The problems:

1. The order of the first and last name is random. It can be Mike Smith or Smith, Mike or Mike J Smith. The constant is that the name always comes after VS.

Examples:

(Na) vs Wright Charline

ABC LLC vs Perry Marquita

Midfield Oriental Ll vs Jovanovic Olivera

Bank of Simpleton, N vs Dow Bonnie Lynn

(Na) vs Rabelo SUSAN

CAPITAL 2 Bank vs Ruiz SUSAN

CAVALI , LLC vs Kifarkis John

Midwest Ll vs Agnew Ed

CALTANA Spv I LLC vs Jackson Christophe

The lists contain up to a million entries at a time.

We can supply a list of first names. The tool should be offline for desktop.

Thanks,

Marc

Skills: Excel, Data Entry, Data Processing, Visual Basic, Data Mining

See more: web data extraction visual basic code excel, data extraction excel address phone, excel data extraction address, pdf data extraction excel data, excel data extraction java, excel sheet data extraction pdf vba, excel macros extraction data, excel data extraction script, data extraction web excel, vb6 data extraction excel samples, excel data validation extraction, excel data extraction day, vba excel data extraction, excel data extraction joomla library, excel data extraction joomla, excel data extraction macro

About the Employer:
( 0 reviews ) Miami, United States

Project ID: #20286624

Awarded to:

MonisZafar

Hello, I've read your project requirements thoroughly. It's a very easy task and can be achieved through Excel Macro which would hardly take 2 hours.

$45 USD in 1 day
(3 Reviews)
2.1

54 freelancers are bidding on average $133 for this job

e3d

Hi, I have such tool to parse first/last names from string readily available. please contact me so we can discuss.

$199 USD in 3 days
(250 Reviews)
8.7
Toperfection

Hello there, We have reviewed the requirements and are interested in offering our services. We have strong knowledge of platforms like LinkedIn, Hoover, Xing and other similar platforms which are useful in finding tar More

$50 USD in 3 days
(184 Reviews)
7.9
asin1987

Dear Marc, If the pattern can be first/last or last/first name then we will get two records for each one. Please message me to discuss further. I will do the job for you. Thanks and Regards, Ash

$250 USD in 7 days
(182 Reviews)
7.6
dgled

Hi, I’ve done many similar projects where the task was to extract and clean up duplicate details and rearrange content or to separate info in some columns ( such as names, addresses and products etc.). I do the project More

$250 USD in 7 days
(81 Reviews)
7.0
dvcontact

Hi, Would you like to see a quick demo of your project on building a tool that will extract and split first names, middle names and last names from one cell to different cells in the order completed before you award th More

$150 USD in 3 days
(51 Reviews)
6.3
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible More

$150 USD in 3 days
(102 Reviews)
6.2
sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I read your project descriptions carefully, I am proficient with Microsoft Excel and macro/VBA development, I can write More

$200 USD in 3 days
(86 Reviews)
5.9
nvchien94

Hello there, I am an Excel VBA expert. I can give you simple VBA macro run on Excel so you can get your data. Please contact me. I can complete it in 1 hour. Thank you.

$50 USD in 1 day
(114 Reviews)
5.7
adeelpirzada

Hi, I would be eager to hear from you i have done scrapping almost on Half of Worldwide web including eCommerce giants (Amazon, eBay, craigslist) News Feed, Social media websites, API's. I develop my own scrape More

$175 USD in 7 days
(12 Reviews)
5.6
mohamedrdait

Hello I can achiev this project perfectly usinf Excel vba or python please contact me for more details about the project best regards

$180 USD in 5 days
(25 Reviews)
5.4
Piao217

Hi, This is Wang from China. I read your post with interest and I can handle it. The challenge is extracting the first name from the names and I think we need to agree that I will use only the ones you provide. I have More

$222 USD in 1 day
(12 Reviews)
5.5
xinglong717

I have many experiences in excel vba. I can show you my projects via chatting. I can complete your project successfully. Thanks.

$140 USD in 7 days
(11 Reviews)
4.2
ozo42

Hi. I can write a python script to do it. It's cross platform - win, linux, mac. Please send me a file for testing.

$124 USD in 1 day
(3 Reviews)
4.2
dungforever

Hi. + I can complete your project in 1 day + I've read your requirements carefully. I understood your requirement and I have full experience in string vb, excel vba. I am a certified freelancer with great ideas & metho More

$100 USD in 7 days
(8 Reviews)
4.0
haleem0786

i can do it. i have good command over ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please inbox me for detail. Thanks

$90 USD in 2 days
(19 Reviews)
3.8
imfarrukh47

Hi, I am an expert in excel. I can extract the 1st name from the given list using builtin excel tools (not VBA) and also teach you how to do it. I tested it on sample data and its working. send me a message I will prov More

$50 USD in 1 day
(7 Reviews)
3.8
paulodayto08

Hi Good Day! A serious freelancer here. I'll create you a formula or macro that can extract your required information. But need to have a 200USD rate for the millions of entries you've said. I've done a lot of Reports More

$200 USD in 2 days
(28 Reviews)
3.9
Guptapuru304

Sir/Ma'am, I am senior python developer and have been working for 3 years now. I have done such works previously with excel and csv, and can deliver it to you in less than a day. I can also help you in form of any s More

$99 USD in 2 days
(2 Reviews)
3.6
rashedkhanrubel

Hi, I have understand the project requirement & interested to extract the data from cells. I will complete this project within very short time. Please send a message so we can discuss more & start the project. Thanks.

$30 USD in 1 day
(11 Reviews)
3.4
TopDesigner315

Hello,sir. I have checked your project specification. I have experience of +10 years working with excel,vba and so on. I can implement your project with fully and completely. I can help you with my best. Thanks for you More

$140 USD in 7 days
(7 Reviews)
3.6