Cut, paste and format excel cells
$30-250 USD
Paid on delivery
I have eight excel worksheets that each contain two columns, “Description” and “Ingredients” with approximately 10,000 individual rows total. This project requires that specific ingredient information be cut from the individual “Description” cells and then pasted into the corresponding “Ingredients” cells. ALL information that is related to "ingredients" must be cut from the “Description” cell and pasted into the corresponding “Ingredients” cell and then formatted. If no ingredient information is found in the “Description” cell, the cell should be skipped, but never deleted.
Any information listed under the following should be cut from the “Description” cell and then pasted into the “Ingredients” cell and then excess carriage returns should be removed from “Description” and “Ingredients” cells for readability:
ALL Information, including the word "Ingredients," following the word "Ingredients:" – with or without capitalization or colon
* Will be sectioned off by a carriage return or information that needs to be cut and pasted will begin and/or end with carriage return
ALL Information, including the words "Other Ingredients," following the words "Other Ingredients:" – with or without capitalization or colon
* Will be sectioned off by a carriage return or information that needs to be cut and pasted will begin and/or end with carriage return
ALL Information, including the word Contents, following the word "Contents:" or "CONTENTS:" – with or without capitalization or colon
* Will be sectioned off by a carriage return or information that needs to be cut and pasted will begin and/or end with carriage return
ALL Information, including the words "Amount per serving", following the word "Amount per serving"– with or without capitalization or colon
* Will be sectioned off by a carriage return or information that needs to be cut and pasted will begin and/or end with carriage return
**Any words, lines or information that might be considered additional ingredients or that could be describing ingredients should be cut from the “Description” cells and pasted into the “Ingredients” cells.
All excess carriage returns or line breaks (2+ carriage returns) must be removed from both the “Description” and “Ingredients” cells and replaced with 1 carriage return.
Where information is separated with multiple comas, i.e. X:a, b, c, d, the comas should be replaced with carriage returns so that each word or description is on a separate line, i.e.:
X:
a
b
c
d
For formatting purposes, only one carriage return should be between lines.
In order to complete this project, a 99% accuracy rate must be achieved.
Project ID: #1403082
About the project
38 freelancers are bidding on average $95 for this job
Sorry, I cant give you 99% accuracy. Because I only believe in 100% ;) Excel whiz here! Please see PMB
SIR, MY BID IS = $40 [WHOLE JOB] I WILL COMPLETED THIS JOB WITH 100% ACCURACY WITHIN 1 DAY. BECAUSE WELL KNOW WORKING KNOWLEDGE OF DATA'S FORMATTING WORK. PLEASE CHECK YOUR PM.
Just need to make it big in life!!! It will be awesome in case you can help me take a step forward!! Thanks.
Dear Sir/Mam,i am too interesting for this project, I have good experience in these work and . plz give me an chance.
Hi, Thank you for such a well descriptive project. I have good hands on MS Excel. I would like to take the opportunity to do a good job with you. I look forward to your reply. Sincerely, Mohammad Waliul Is More
SIR, I am new as a freelancer but i can gurantee u that i can do this job as early as possible