There are Approx. 17 tabs of data in a spreadsheet where the data needs to be cleaned up prior to importing into a CRM project.
For each tab:
1. Where ever you see a person full name in one cell this needs to be separated into two cells called First_name and Last_name
2. Where ever there is a full address in one cell this needs to be separated into multiple cells with names: addr_1, addr_2, Town, State, pcode, country
3. Where there is a company name, match the company name with its ID in the DataSource tab
4. Add the User SFID against each row in a sheet for the user name in the tab for that sheet looking up from the tab SF_User_ID
5. All phone numbers need to have a leading 0. Probably something like convert to text and concatenate with a leading zero. All phone fields to only contain numbers not text or dashes etc
6. Combine all tabs into one sheet where the (currently inconsistent) columns are all alligned
9 freelancers are bidding on average $148 for this job
I am offering my services against your esteemed work. Great quality work will be provided to you in order to create and make long term relations on the basis of commitment, your problem solution and satisfaction
Hi, I am fully available now. So I can finish this job as quick as possible. I have finished all my previous jobs with 100% completion rate in time and within budget. So you can trust me.
I have a good experience in data entry and excel to and also have lots of time to do home base work with skills and [url removed, login to view] understand the project need and m ready to work on this project dedicately
Hi alvincorwin, I am skilled with Excel, good with data manipulation/cleaning and have an eye for detail. I believe I am a good candidate for this task. Thank you for your consideration. Regards.
Hi, I have worked on many similar projects in my 17 yeras of job. I am good in excel related work. I am ready to work on this project. If you are interested, please provide me more details. Regards Gopal