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.
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.
48 freelancere byder i gennemsnit $19/timen for dette job
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
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
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
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 .