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.

Habilidades: Entrada de datos, Procesamiento de datos, Excel, Visual Basic

Ver más: macros work excel internet, macro dont work excel 2000, freelance work excel vba, 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

Información del empleador:
( 13 comentarios ) Melbourne, Australia

Nº del proyecto: #11754425

Adjudicado a:


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 Más

$30 USD en 1 día
(67 comentarios)

13 freelancers están ofertando el promedio de $29 para este trabajo


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 en 1 día
(103 comentarios)

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 Más

$30 USD en 1 día
(73 comentarios)

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 Más

$25 USD en 1 día
(23 comentarios)

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

$25 USD en 1 día
(26 comentarios)

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 Más

$20 USD en 1 día
(21 comentarios)

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 en 1 día
(3 comentarios)

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 Más

$25 USD en 1 día
(0 comentarios)

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 Más

$25 USD en 5 días
(0 comentarios)

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 Más

$25 USD en 1 día
(0 comentarios)

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 en 2 días
(0 comentarios)

A proposal has not yet been provided

$10 USD en 2 días
(0 comentarios)
$30 USD en 1 día
(0 comentarios)
$29 USD en 1 día
(0 comentarios)