Færdiggjort

Excel macro or logic functions to sort data

I have a spreadsheet with 6300 rows of data.

There is a lot of data in an incorrect format.

I would like the format to be changed.

For example

Family name from all uppercase to proper case.

Multiple mobile phone number formats. I would like 0000 000 000 format.

There are multiple entries for one person. I would like all the contents of 5 cells put in to 1 cell in a certain format.

Then delete extra entries.

A sample will be available.

Thank you

Evner: Excel, Dataindførsel, Databehandling, Visual Basic, Visual Basic for Apps

Se mere: excel macro data cell, data net web application excel macro, excel macro move data existing cell, excel sort dynamic data with duplicates, excel vba sort column descending, auto sort excel without macro, how to auto sort multiple columns in excel, excel auto sort macro, how to create a sort macro in excel, excel sort(array formula), excel vba sort multiple columns, excel macro copy data column, excel macro enter data database, data web excel macro, excel macro add row fill data, excel macro vba functions cut paste, excel macro visit website pull data, excel macro import file parse data, excel macro choose tab paste data, excel macro input large amount data

Om arbejdsgiveren:
( 3 bedømmelser ) Sydney, Australia

Projekt ID: #26972710

Tildelt til:

finecodervw

Hi, As I understand you would like to have the data corrected in the Excel file along with removal of duplicate data. It would help if you can please share the file. Keen to work on this project. Please suggest suita Flere

$15 AUD / time
(148 bedømmelser)
6.6

48 freelancere byder i gennemsnit $19/timen for dette job

TypingxpertRehan

It has to be done manually, no macro or script can do it since there will be plenty of formats of those 6300, i can get this done manually according to your needs, thanks

$25 AUD / time
(1504 bedømmelser)
9.3
schoudhary1553

Hi, Greetings! ✅checked your project details: Excel macro or logic functions to sort data ✅Completed Time: In project deadline We have worked on 650 + Projects. I have 6 + years of the experience in same kind of Flere

$25 AUD / time
(438 bedømmelser)
8.3
(339 bedømmelser)
7.9
(101 bedømmelser)
7.5
(309 bedømmelser)
7.3
best4best

Hi, I can convert the spreadsheet with 6300 rows in desired format using Excel formulas. I am ready to start the project now. Please share the sample. Regards MS

$15 AUD / time
(213 bedømmelser)
6.7
bhupendrayadav

I am full time freelancer, providing automation consultancy to SME/MSME companies. I can develop an Excel based automation tool to auto format your data as per your requirements. Below is a brief introduction of myself Flere

$20 AUD / time
(47 bedømmelser)
5.8
writingapp

Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 2 hours

$20 AUD / time
(111 bedømmelser)
5.9
narsim3128

NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. I CAN COMPLETE THIS TASK IN QUICK TIME. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT expe Flere

$15 AUD / time
(73 bedømmelser)
6.1
(118 bedømmelser)
6.0
IgeS

Hi there, Need a macro/ built-in formula to clean and format/ stack your data? Please message me if this is any of what you need. I’ll be standing by to help. -Reggie

$16 AUD / time
(35 bedømmelser)
5.2
lisamarlen168

I notice your project description and am really excited about this Project. We can discuss on freelancer chat list and I will do the work of your requirement. Send me a message on the Freelancer Chat list for discussio Flere

$15 AUD / time
(28 bedømmelser)
4.1
Mohilm007

Hi, I have read your requirement :- Excel Macro & logic Function to short data I have 7+ years of experience in MIS. I am expert in Excel and have an excellent in VBA . If given a chance, I can do this work easily for Flere

$22 AUD / time
(6 bedømmelser)
3.7
SusanTeke

Hi there! I'm experienced and proficient in MS Excel as well as being meticulous, patient and accurate. That's why I'm confident that I'll be able to sort out your spreadsheet and return it to you in the format you req Flere

$15 AUD / time
(14 bedømmelser)
3.7
ShivaniGoyalsai

Hi Employer, I have 8 years of experience in excel and vba programming. I have understood your requirements and worked on similar projects in the past so i would be able to deliver the project with quality and with in Flere

$15 AUD / time
(15 bedømmelser)
3.8
greencoders

Hi, there I am very interested in your post project. I am really looking for this kind of project for a long time in freelancer since i have rich experience on it. I think this project is very suitable for me and i am Flere

$15 AUD / time
(2 bedømmelser)
2.7
wengelgar

Hi! I am an accountant and excel is something I use everyday. I'm not really familiar with macro but I know logical functions like the back of my hand. I can give you a sample work for the first few rows so you will k Flere

$25 AUD / time
(7 bedømmelser)
2.4
RTYSDAL

I have 25 years experience creating Excel applications for a major computer company. I can take on this project at a reasonable cost and fast turn around.

$15 AUD / time
(3 bedømmelser)
1.8
cmasandeepc

Dear Sir, I have more than 5 Years of experience in the same field & also i think i can give the deliverable within time.

$15 AUD / time
(0 bedømmelser)
0.0
orabiomar6126

get free sample,I read the description very well and ready o start working directly. hello sir, I have a good experience in data entry and hope to have a perfect work with each other .

$15 AUD / time
(0 bedømmelser)
0.0