Find Jobs
Hire Freelancers

Parse Address

$10-30 USD

Selesai
Disiarkan lebih dari 5 tahun yang lalu

$10-30 USD

Dibayar semasa penghantaran
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?
ID Projek: 17941770

Tentang projek

13 cadangan
Projek jarak jauh
Aktif 5 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
"""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 dalam 1 hari
4.9 (163 ulasan)
6.5
6.5
13 freelancers are bidding on average $30 USD for this job
Avatar Pengguna
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 dalam 1 hari
5.0 (623 ulasan)
8.3
8.3
Avatar Pengguna
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 dalam 1 hari
5.0 (263 ulasan)
7.5
7.5
Avatar Pengguna
hi, i see ur file and i can do this right now, thanks....
$20 USD dalam 1 hari
4.8 (136 ulasan)
6.0
6.0
Avatar Pengguna
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 dalam 1 hari
4.7 (92 ulasan)
6.0
6.0
Avatar Pengguna
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 dalam 1 hari
4.7 (59 ulasan)
5.3
5.3
Avatar Pengguna
Hi There, I do this for my most of the projects. I can show you a simple and easy method. Regards Imran
$15 USD dalam 1 hari
5.0 (33 ulasan)
4.4
4.4
Avatar Pengguna
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 dalam 0 hari
4.7 (49 ulasan)
4.7
4.7
Avatar Pengguna
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 dalam 3 hari
4.9 (13 ulasan)
3.4
3.4
Avatar Pengguna
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 dalam 1 hari
4.3 (6 ulasan)
1.8
1.8

Tentang klien

Bendera UNITED STATES
Chesapeake, United States
5.0
2
Kaedah pembayaran disahkan
Ahli sejak Okt 28, 2017

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.