Moving address into cells using excel formula
- or -
Post a project like this1818
£30(approx. $38)
- Posted:
- Proposals: 5
- Remote
- #2374473
- Awarded
Description
Experience Level: Entry
Hello
I have a data base or 2000 entries but the address appears in 1 field and I need it to be in separate fields for my CRM
In the attachment - I have 2000 entries like the RED and need them changing to the BLUE
Top line is 'Address 1'
second line is 'Address2'
3rd line (if there is one) 'Address 3'
Town can be used if needed for a 4th line
The 'County' field is the most important. This is always above the post code and MUST be in the County field
Post code can be deleted as its already been done.
Not really sure how long this will take someone so the budget may vary. Perhaps really quick if you can do it all on formula??
Please don't change any of the other fields
Any questions let me know
I have a data base or 2000 entries but the address appears in 1 field and I need it to be in separate fields for my CRM
In the attachment - I have 2000 entries like the RED and need them changing to the BLUE
Top line is 'Address 1'
second line is 'Address2'
3rd line (if there is one) 'Address 3'
Town can be used if needed for a 4th line
The 'County' field is the most important. This is always above the post code and MUST be in the County field
Post code can be deleted as its already been done.
Not really sure how long this will take someone so the budget may vary. Perhaps really quick if you can do it all on formula??
Please don't change any of the other fields
Any questions let me know
Graham M.
100% (30)Projects Completed
23
Freelancers worked with
12
Projects awarded
61%
Last project
27 Mar 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