Find Jobs
Hire Freelancers

Parse Address

$10-30 USD

Completed
Posted over 5 years ago

$10-30 USD

Paid on delivery
Three address types: (WANT EXCEL FORMULAS - NOT A MACRO) (1) if, ", APT - extract ", APT and everything to the right until the next comma including the next comma - output results in columns C & D per example in attached file. (2) if, " STE - extract " STE and everything to the right until the next comma including the next comma - output results in columns C & D per the example. (3) =LEFT(b5,FIND(",",b5)-1) - works - maybe a better way?
Project ID: 17941770

About the project

13 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
$30 USD in 1 day
4.9 (163 reviews)
6.5
6.5
13 freelancers are bidding on average $30 USD for this job
User Avatar
Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample file before you consider awarding me the project. Please initiate a chat so we can discuss on this. Thanks, Jay
$35 USD in 1 day
5.0 (623 reviews)
8.3
8.3
User Avatar
This is Vibrant Webtech and I was glad to see that you're looking for help for project Parse Address . I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.I have more than 5 year of experience in Excel. Please ping me for more discussion.
$40 USD in 1 day
5.0 (263 reviews)
7.5
7.5
User Avatar
hi, i see ur file and i can do this right now, thanks....
$20 USD in 1 day
4.8 (136 reviews)
6.0
6.0
User Avatar
Hi there, I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, MOHIUDDIN.
$25 USD in 1 day
4.7 (92 reviews)
6.0
6.0
User Avatar
Hello, I am ready to discuss project with you. Being experienced in working on several excel projects involving various formula of complicated use, I can help you in writing formula as you mentioned. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Vimal Arora
$20 USD in 1 day
4.7 (59 reviews)
5.3
5.3
User Avatar
Hi There, I do this for my most of the projects. I can show you a simple and easy method. Regards Imran
$15 USD in 1 day
5.0 (33 reviews)
4.4
4.4
User Avatar
Hi, Hope you are doing well. I have reviewed the project description along with attached .excel file and able to provide formula that will be able to separate STE, APT, UNIT, CONDO, # to its destination filed. I make sure you that the task will be accomplished by today itself in the given budget of $15. If you have any question, please feel free to contact me. I am waiting for your kind response. Thank you
$15 USD in 0 day
4.7 (49 reviews)
4.7
4.7
User Avatar
Hello, I am happy to inform you that I have read your project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards
$100 USD in 3 days
4.9 (13 reviews)
3.4
3.4
User Avatar
Hi Madam/Sir, Project Specific Comments: ------------------------------------------- I will be able to parse the Data as per the Formula you have mentioned. I have done many formula like this including Array formula to parse such details in Excel sheets. General Profile Information: ------------------------------------------- Also, am 15 yrs Experienced in MS Word, Excel Macro, VBA, Word, Office Automation & blogging on Office Tricks & tips. I work full time in here & will be able to start your work immediately. Services Provided: 1. Excel Macro (VBA) 2. Word PRocessing 3. Excel Pivot Charts & Tables 4. Excel Auto Filter, Vlookup, Formula Assistance 5. Excel to Access 6. User Forms in Excel 7. Calendars in Excel 8. Bulk Files Processing in side a Folder 9. Folder Operations 10. Sending Email from Excel 11. Extract Data from Webpages Please drop a message once you feel comfortable with my profile & lets get started. Thanks for your time
$25 USD in 1 day
4.3 (6 reviews)
1.8
1.8

About the client

Flag of UNITED STATES
Chesapeake, United States
5.0
2
Payment method verified
Member since Oct 28, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.