Encerrado

RB CLEANUP - repost

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, Processamento de dados, Excel, Powerpoint, Word

Ver mais: rb, concatenate, combine excel, excel convert text address, tab separated, excel combine, excel match columns row, zero data entry, 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, excel match columns, excel address phone numbers, spreadsheet cleanup, match company names, cleanup spreadsheet, numbers spreadsheet convert excel, crm excel, convert spreadsheet numbers

Acerca do Empregador:
( 0 comentários ) Indonesia

ID do Projeto: #5130743

9 freelancers estão ofertando em média $148 para este trabalho

topacademics

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

$164 USD in 4 dias
(4 Comentários)
4.3
PrincyJohn

***** Please Message Me to Send More Samples ***** Dear Sir/Madam, Greetings! I am very much eager to work with your project as I have completed many Excel and Presentation projects which includes creation of Mais

$83 USD em 1 dia
(4 Comentários)
2.7
ajpsarita

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.

$88 USD em 1 dia
(3 Comentários)
1.6
PeterrKhan

Hello, I can do this work TODAY. I will be available for modifications and reviews to ensure your demands are met. I work with Excel files all day long and I know exactly what and how to do it. I fully commit to pro Mais

$100 USD in 0 dias
(1 Comentário)
1.5
nishabaghel

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 technique.Also understand the project need and m ready to work on this project dedicately

$155 USD in 5 dias
(0 Comentários)
0.0
ART4000

Aucune proposition n'a encore été fournie.

$222 USD in 7 dias
(0 Comentários)
0.0
SakshiV06

Hello, I have been working on spreadsheets since past 2 years, including clean up and other data processing jobs. I will ensure that you get the highest quality output in the shortest time possible. You will not be Mais

$150 USD in 4 dias
(0 Comentários)
0.0
AussieCADdesign

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.

$200 USD in 5 dias
(0 Comentários)
0.0
gop1410

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

$166 USD in 7 dias
(0 Comentários)
0.0