Do some Excel Work

Use some macros or formulas to clean the data in my workbook.

I have a workbook with 45288 rows in it.

There are only a few column.

I require someone to:

Duplicate the Author Metadeta column, so that there is an Author Metadata column as well as an Author column.

Then, in the new Author column, someone will need to run some formulas or scripts to make sure that there is only one name in there.

For example, some fields have the illustrator's name along with the authors name:

i.e H. de Graffigny; illustrated by Ferdinand Raffin

this should be changed to only H. de Graffigny

Most of the data can be delimited by semicolon, comma, full stop etc. However, not all of the data is like this and someone will need to carefully check that there is only ONE NAME in the Author field.

If you see a field that has DUPLICATE or SKIP in the workbook you can move on to the next row. The DUPLICATE or SKIP field is shown in red and replaces the title's name.

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

See more: macros work excel internet, macro dont work excel 2000, freelance work excel vba, microsoft excel, track work excel, macros written excel 2000 work excel 2007, contract work excel access, excel 2000 macros work excel 2007, article submission work excel, show project work excel, work excel file, contract work excel, online contract work excel, data entry work excel, work excel database, surf internet work excel

About the Employer:
( 13 reviews ) Melbourne, Australia

Project ID: #11754425

Awarded to:


I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. I have already done 90 works on Freelancer where majori More

$30 USD in 1 day
(67 Reviews)

13 freelancers are bidding on average $29 for this job


Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 USD in 1 day
(103 Reviews)

Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before More

$30 USD in 1 day
(73 Reviews)

Hello... I am highly interested to do your project. I beleive that, I can do this work properly and in timely by your instruction. Always determined to give you a best work. Moreover, I have a group which consist More

$25 USD in 1 day
(23 Reviews)

contact me sir i can do this........................................................................

$25 USD in 1 day
(26 Reviews)

Respected Sir, I am interested in your project. I have excellent Microsoft Excel and VBA programming skills which will be of excellent value for your project. I understand your project need. You have More

$20 USD in 1 day
(21 Reviews)

Hi Sir, I have a previous project same with you where he's number of row data where over 16000. I really believe I can help you. Can you provide me the excel file ? :) Best regards, Flora

$25 USD in 1 day
(3 Reviews)

Hello,We are a team of developers and do all work related to computer science( Software Engineering ),. We have experience in , JAVA,C# ,My SQL , website Design( wordpress ,PHP), Excel, ( vb ,(macro)), Data Entry, Grap More

$25 USD in 1 day
(0 Reviews)

Hi There, i understand your requirements and i can do it exactly. though i am new in but i have done few task in fell free to contact with me.i have done few job in upwork. looking f More

$25 USD in 5 days
(0 Reviews)

Hi, This is Ganesh Netha from Hyderabad. I've gone through your business proposal. and understood the overview. I wanted to work with you on this project. I was working for different US based processes as a Pro More

$25 USD in 1 day
(0 Reviews)

i can do your work according to your requirements.i hope you will like my work,.just give me chance to complete your work properly.

$55 USD in 2 days
(0 Reviews)

A proposal has not yet been provided

$10 USD in 2 days
(0 Reviews)
$30 USD in 1 day
(0 Reviews)
$29 USD in 1 day
(0 Reviews)