Suoritettu

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

Taidot: Excel, tiedonsyöttö, tietojenkäsittely, Visual Basic, tiedonlouhinta

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Miami, United States

Projektin tunnus: #20286624

Myönnetty käyttäjälle:

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 1 päivässä
(3 Arvostelua)
2.1

54 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

e3d

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

$199 USD 3 päivässä
(250 arvostelua)
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 Lisää

$50 USD 3 päivässä
(184 arvostelua)
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 7 päivässä
(182 arvostelua)
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 Lisää

$250 USD 7 päivässä
(81 arvostelua)
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 Lisää

$150 USD 3 päivässä
(51 arvostelua)
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 Lisää

$150 USD 3 päivässä
(102 arvostelua)
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 Lisää

$200 USD 3 päivässä
(86 arvostelua)
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 1 päivässä
(114 arvostelua)
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 Lisää

$175 USD 7 päivässä
(12 arvostelua)
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 5 päivässä
(25 arvostelua)
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 Lisää

$222 USD 1 päivässä
(12 arvostelua)
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 7 päivässä
(11 arvostelua)
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 1 päivässä
(3 arvostelua)
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 Lisää

$100 USD 7 päivässä
(8 arvostelua)
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 2 päivässä
(19 arvostelua)
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 Lisää

$50 USD 1 päivässä
(7 arvostelua)
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 Lisää

$200 USD 2 päivässä
(28 arvostelua)
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 Lisää

$99 USD 2 päivässä
(2 arvostelua)
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 1 päivässä
(11 arvostelua)
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 Lisää

$140 USD 7 päivässä
(7 arvostelua)
3.6