I have contact database in an Excel spreadsheet that needs to be cleaned and formatted so it is consistent throughout the list. There is a total of about 9400 names. I have attached before and after samples to give an indication of what needs to be changed.
To make it absolutely clear, the main fields that need to be formatted are:
1. Phone number - Change to XX XXXX XXXX (correct spaces, no brackets, area code added if not there)
2. Fax number - As above, change to XX XXXX XXXX
3. Mobile - Change to XXXX XXX XXX format.
4. Website - Change to [url removed, login to view] (remove http:// etc.)
5. Principal - Split this into First and Last as per After sample attached, remove the title (eg. Mr)
Any questions please ask. I will send the full contact database once I have awarded the project.
Đã trao cho:
23 freelancer đang chào giá trung bình $78 cho công việc này
Hi, list cleaning experts here. We've done a lot of similar jobs before and we're familiar with Australian phone numbers as we have a lot of Aussie clients. We can help.
Ready to start and can assure you that I can complete in time and with better quality according to your requirements. Please check PM for details. Thank you!