W Toku

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.

Umiejętności: Wprowadzanie danych, Przetwarzanie danych, Excel, Visual Basic

Zobacz więcej: 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

O pracodawcy:
( 13 ocen ) Melbourne, Australia

Numer ID Projektu: #11754425

Przyznane użytkownikowi:

Tanmoy236

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 Więcej

$30 USD w 1 dzień
(67 Ocen)
5.7

13 freelancerów złożyło ofertę na średnią kwotę w wysokości $29 do tego projektu.

P0L

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 w ciągu 1 dnia
(103 Ocen)
6.2
rohitpithisaria

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 Więcej

$30 USD w ciągu 1 dnia
(73 Ocen)
5.8
sadekhosen77

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 Więcej

$25 USD w ciągu 1 dnia
(23 Ocen)
4.6
DataShu

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

$25 USD w ciągu 1 dnia
(26 Ocen)
4.5
kvosaravana

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 Więcej

$20 USD w ciągu 1 dnia
(21 Ocen)
3.8
fixen2011

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 w ciągu 1 dnia
(3 Ocen)
1.9
MECHATRONS

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 Więcej

$25 USD w ciągu 1 dnia
(0 Ocen)
0.0
harunur93

Hi There, i understand your requirements and i can do it exactly. though i am new in [url removed, login to view] but i have done few task in upwork.com. fell free to contact with me.i have done few job in upwork. looking f Więcej

$25 USD w ciągu 5 dni
(0 Ocen)
0.0
nethaganesh

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 Więcej

$25 USD w ciągu 1 dnia
(0 Ocen)
0.0
hasratkhan009

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 w ciągu 2 dni
(0 Ocen)
0.0
sivaihvf

A proposal has not yet been provided

$10 USD w ciągu 2 dni
(0 Ocen)
0.0
$30 USD w ciągu 1 dnia
(0 Ocen)
0.0
$29 USD w ciągu 1 dnia
(0 Ocen)
0.0