Realign data within a Excel spreadsheet.
- or -
Post a project like this1714
£80(approx. $99)
- Posted:
- Proposals: 29
- Remote
- #2460867
- Awarded
Data Scraping/ Mining/ Extraction, Data Entry, Researcher, Shopify, WordPress, Product Uploading, Excel Geek, Admin Support
New Delhi
Internet Researcher/Research/Data entry/Lead generation/Data collection/Web search/Data scrapping/Market research/PDF conversion/web scrapping/virtual assistant/Email database/Excel/Email Database
Vadodara
Data scraping / data mining / data extraction / web scraping / scraping / data conversion / General admin support and more
Kent
16684402288803173320018878031971398205774520874402096116282656928006772778891139058
Description
Experience Level: Expert
I have an Excell spreadsheet with 1762 contact entered into it. The address are entered into one field and I need these splitting into 5 separate fields Add1, Add,2 Town, County, Postcode. I have been using the 'Data - Text to Columns' feature within Excel to convert these but have found the addresses are not al the same format so you can't do this globally but need to work through each one individually or a batch together. I have complete 285 entries but need the remaining 1477 sorting out.
Greg R.
100% (17)Projects Completed
17
Freelancers worked with
15
Projects awarded
55%
Last project
23 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies