Excel/CSV - Convert words to numbers

We currently have a web site that needs updating. The way it is updated is via a csv file (attached). There are close to 100 manufacturers that have thousands of products. Each manufacturer is split up into its own spreadsheet. In the spreadsheet example provided, you will see what you will start with and how we need the file to be returned to us. References for the numbers' values will be provided (This will tell you the numeric value of a name,; after viewing the attached file, it'll make sense).

Another part of this project is that there are product names which need to be replicated, but the model number and option (color, size, etc) needs to be removed.

Example: Product Name modelnumber-1a Black product

Product Name modelnumber-1b White product

Result: Product Name modelnumber product

(A better example is in the attached file)

You must have experience with this. It is simply a matter of filtering columns and replacing a word with a number. Turn around time for each file should be, at most, 3 days. Over the length of time, there will be many files, so if you do a good job and are fast and accurate at this, then you will be awarded all data entry projects for the future.

Habilidades: Processamento de Dados, Processamento de dados, Excel

Veja mais: what is numeric data entry, we excel, n numbers, names and numbers, manufacturers products, job values, how to manufacturer a product, have a product need a manufacturer, convert number to words in excel, convert job, convert file to, black names, convert words numbers spreadsheet, convert words numbers, convert words numbers excel, what is word processing, excel split columns, csv spreadsheet, another word for data entry, manufacturer needs of a product, word excel projects, word convert, what we have to do in data entry job, numeric, how to close the project

Acerca do Empregador:
( 41 comentários ) Staten Island, United States

ID do Projeto: #599569

Concedido a:


Dear sir, I have extensive expertise on processing data on spread sheet. For details please check PM. Thanks.

$30 USD em 1 dia
(108 Comentários)

6 freelancers are bidding on average $38 for this job


Hello Sir/Madam, *************** SPECIAL BID WAITING FOR START****************I have 45 workers in my own office with three Internet connections and 24x7 UPS and Gen-Set backup. My all workers have good experience in F Mais

$30 USD in 0 dias
(148 Comentários)

Hi, Let's Start right away!

$30 USD in 0 dias
(47 Comentários)

Ready to work with you. Thanks, Al

$80 USD em 1 dia
(19 Comentários)

Please check the PMB.

$30 USD em 1 dia
(0 Comentários)

I have wide expertize on it Excel as well as database desigening.I made Accounting Software. I hope i would support you properly,if you rely on me.

$30 USD in 0 dias
(0 Comentários)