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

Habilidades: Processamento de Dados, Excel

Veja mais: RB, Concatenate, combine excel, excel convert text address, tab separated, excel combine, excel match columns row, zero data entry, combine row data cell excel, project cleanup spreadsheet, cleanup names, match columns excel, convert columns text excel, convert excel text, data cleanup excel, excel spreadsheet convert numbers, excel crm spreadsheet, convert numbers spreadsheet excel, convert numbers spreadsheet excel spreadsheet, excel match columns, excel address phone numbers, spreadsheet cleanup, match company names, cleanup spreadsheet, numbers spreadsheet convert excel

Acerca do Empregador:
( 23 comentários ) Mosman, Australia

ID do Projeto: #5130411

Concedido a:


Well hi, i wasn't sure, how much to bid. Btw i m really glad everything is working fine. I really worked a lot for this (much more then last time), but this should be ok price for this, i don't know really. I m very Mais

$90 AUD em 0 dias
(7 Comentários)

56 freelancers estão ofertando em média $99 para esse trabalho


Hi timmolloy, I can help you to order your excel data. I can do it with 100% accuracy and on time. I have good skills in data entry, manage data, and with excel. I have a good internet connection and I'm availa Mais

$35 AUD in 3 dias
(7 Comentários)

Respected Sir, It would be pleasure for me to render my services to you for cleaning the excel sheet with given parameters. I am an expert level user of Excel, my profile is enough to prove this skill. I guarantee y Mais

$50 AUD in 0 dias
(49 Comentários)

Hi, We are good at this type of work, ready to take data from all the 17 tabs and form a new sheet and clean up all the information exactly according to your description. Please see my reviews in the below url ht Mais

$131 AUD in 3 dias
(140 Comentários)

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n Mais

$88 AUD in 5 dias
(26 Comentários)

Hello, I have done similar jobs before, I do believe I can do a very good job for you. I hope you will consider my bid. Thank you, Elvira

$55 AUD in 3 dias
(36 Comentários)

Dear, I will code a VBA macro to format the data according to the structure you mentionned. NO manual tasks and the macro can be used for future needs. I will provide the code + how to use it. I have to check the sou Mais

$88 AUD in 3 dias
(38 Comentários)

Hi, Highly experienced data entry operator. Expertise in Advanced Functions of MS Excel. Read and understood your description. Ready to start, please reply soon. Thanks, Virendra

$45 AUD in 3 dias
(3 Comentários)

"Dear employer, I am a highly trained Data Entry, web search, web scrape, product add any type of card, Expert with great knowledge of Excel and all Social Networks. My bid is optional and I will let you chose the pri Mais

$100 AUD in 3 dias
(271 Comentários)

Hi, I am interested in your project. You can count on me for a fast and 100% accurate job done. Thanks & regards, Peter

$70 AUD in 4 dias
(38 Comentários)

Hello, I have BBA degree, management in IT, I work in sales and I am ms office expert. I can help you with this. Can you please provide some sample or share your actual file prior to awarding project? You can check m Mais

$60 AUD in 3 dias
(17 Comentários)

Hi Tim, Just saw your project and would like to help you again with this one. Kindly provide me with the files and I will start working on this. Looking forward for your reply. Cheers, Susanto

$100 AUD in 3 dias
(23 Comentários)

Hi there, I have extensive experience in excel/VBA/macros. I am very interested in your project. Please select my bid and send me the file to start off. Regards, Bharat

$100 AUD in 2 dias
(4 Comentários)

Sir,Thanks for the project. I have understood what you are looking for. I can do this job exactly as you want and with accuracy. I have real work experience in excel and web search. So I can do this very effectively. Mais

$70 AUD in 3 dias
(8 Comentários)

Dear sir/madam, I'm an expert on data entry, web research and find markets for businesses with experience in using MS Office, Open Office, Google docs, HTML, Wordpress ... I have good skills in English, Spanish, Chi Mais

$105 AUD in 3 dias
(103 Comentários)

Hi TIm. I am quite interested in your project. If you like, I can start on it right away.I have done very similar projects before and would be able to handle yours too. Regards

$130 AUD in 2 dias
(18 Comentários)

Dear Sir I can do the work asap as I have did this kind of work earlier also and I am very accurate and dedicated towards my work. So I request you to give me a chance to work for you. Regards Neha

$30 AUD em 1 dia
(2 Comentários)

Hello, greetings. Have a good day. I've read project detail and I'm sure I can do this project perfectly as per your requirement. I'm ready to start. Look forward to hear from you. Thanks and regards, Diem.

$40 AUD in 2 dias
(37 Comentários)

Dear Sir, I am extremely interested to your project and ready to start immediately. Sir if you give me chance I can do this job. I see your project and i do it as your acceptation. I have 3 years experience to w Mais

$155 AUD in 3 dias
(24 Comentários)

Dear timmolloy, Expert here.. Please share data. Best Regards, Microk [url removed, login to view]

$40 AUD in 3 dias
(25 Comentários)

Please check my reviews for my expertise area and buyers saying about my work, if you check my reviews then you see, i've no incomplete project and no bad wording for my work please check my profile here http://www.f Mais

$55 AUD em 1 dia
(151 Comentários)