Find Jobs
Hire Freelancers

Excel formula

€8-30 EUR

Completed
Posted 3 months ago

€8-30 EUR

Paid on delivery
I don't know if this is possible in a formula? The Excel formula should do the following: - Special characters of all kinds should be removed (?,ß,&,-,`,™,®, etc...) - write everything in lower case - Replace spaces with hyphens (-). But with ( - ), not (---) may appear but only (-) - Change umlauts (Ä = Ae, ä=ae, etc...)
Project ID: 37783841

About the project

48 proposals
Remote project
Active 3 mos 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
€0 EUR in 1 day
4.9 (200 reviews)
6.5
6.5
48 freelancers are bidding on average €20 EUR for this job
User Avatar
Hello, I am an Excel/VBA expert and I can write a UDF or macro for getting this done. Please check my profile and contact me to discuss further details. Regards.
€50 EUR in 1 day
5.0 (518 reviews)
8.1
8.1
User Avatar
With significant experience in Data Processing, Excel, Microsoft Office and, Visual Basic, I am your go-to expert for this project. Not only do I understand precisely what you need – to remove special characters, convert to lowercase and format text according to your specified regulations, but I also possess the knowledge and skills to deliver optimized solutions tailored towards maximizing your Excel experience. My deep understanding of Excel VBA enables me to create advanced formulas and customized macros that can tackle intricate tasks like replacing spaces with hyphens as indicated in the project description. Furthermore, my competence in using G-Sheets perfectly aligns with your requirement for a Google Sheets guru which makes me a well-rounded option for you. Drawing on my passion for automation, I will transform the manual aspects of your task into streamlined and efficient workflows that save time and ensure accuracy. As an innovation-driven problem solver, I welcome challenging assignments. Trust me to not only complete the job efficiently but also provide you with thorough documentation so that you can easily understand and maintain the implemented formula even after the project is completed. Choose me for this task and rest easy knowing that your project is in capable hands. Let's get started on optimizing your spreadsheets for an unrivaled data management experience. Hit the 'Hire Me' button now!
€30 EUR in 1 day
4.9 (404 reviews)
7.5
7.5
User Avatar
I can do this project according your requirements. I'm ready to start the project asap. If you message me, we can do further discussion. Thanks.
€20 EUR in 7 days
5.0 (119 reviews)
7.1
7.1
User Avatar
-------------------I CAN DO IT RIGHT AWAY-------------------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VBA Scripting, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul
€25 EUR in 1 day
5.0 (69 reviews)
5.5
5.5
User Avatar
Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh
€30 EUR in 1 day
4.7 (46 reviews)
5.8
5.8
User Avatar
I can do this manually. Good in excel basic Formulas. I can handle excel easily. So available to do manually and using basic formulas. Hope you consider this Bid.
€30 EUR in 1 day
5.0 (26 reviews)
4.5
4.5
User Avatar
I can create VBA excel code rather than Formula.. because in this maybe formula not working for all while VBA excel code will efficient 100 %and faster About me ADVANCE EXCEL , more 7 years experience I am a CERTIFIED Excel VBA Programming , CERTIFIED Business Analytics and Professional Certificate in Excel Accountant i have a MASTER of BUSINESS ADMINISRATION
€25 EUR in 1 day
5.0 (22 reviews)
4.7
4.7
User Avatar
UMAIR HERE! I HAVE READ YOUR INSTRUCTIONS AND I CAN DO IT EFFICIENTLY ACCORDING TO YOUR DESIRES. PLEASE GIVE ME THIS PROJECT I WILL GIVE YOU UNLIMIUTED REVISIONS EVEN AFTER COMPLETION OF THE WORK. WILL WAIT FOR YOUR KIND RESPONSE. THANK YOU
€15 EUR in 1 day
5.0 (53 reviews)
4.3
4.3
User Avatar
Hello As an Excel Expert I can do this job in one day I will remove all the characters and all the characters will be lower case, I can do this job in one day and I can start right now Contact me
€20 EUR in 1 day
5.0 (12 reviews)
3.6
3.6
User Avatar
Hi, i have read and understand your requirements. I have previous experience as well. I can do it for you. Kindly contact over chat to discuss more. Thanks
€27 EUR in 2 days
4.7 (9 reviews)
3.5
3.5
User Avatar
with my extensive 10 years of experience with Excel, I have tackled numerous complex formulas and data processing tasks, similar to this one. Indeed, I can confidently tell you that your requirements are more than achievable using Excel formulas. Handling and transforming data is my specialty; I am proficient with functions like SUBSTITUTE, LOWER, and I am not limited to these functions alone. On top of meeting your immediate needs, I always approach projects with an eye toward scalability and efficiency. Your project description mentions numerous special characters and umlauts that must be removed/changed; well this doesn't scare me! To enhance the formula's performance, we could build it into a Power Query or Macro setup that can be easily reused for future similar tasks. By selecting me, you're choosing an expert who will ensure both accuracy and speed in delivering the outcome you want. My track record of completing projects on time while maintaining the highest quality output speaks for itself. So, let's connect the parentheses (-) and get started on your Excel formula needs today!
€20 EUR in 1 day
5.0 (9 reviews)
3.2
3.2
User Avatar
Hi there, I can adjust your formula to perform all the following; - Special characters of all kinds should be removed (?,ß,&,-,`,™,®, etc...) - write everything in lower case - Replace spaces with hyphens (-). But with ( - ), not (---) may appear but only (-) - Change umlauts (Ä = Ae, ä=ae, etc...) I can deliver this project in 1 Hour Please reach out
€30 EUR in 1 day
5.0 (2 reviews)
2.1
2.1
User Avatar
Drawing from my extensive experience in Excel and my deep understanding of its functions and capabilities, I can confidently say that I am well-equipped to tackle your project. Over the years, I have become proficient in crafting meticulous formulas to automate various data processing tasks just like the one you have outlined. Not only am I skilled in general Excel formulations but also highly proficient in handling string-manipulation tasks similar to sanitizing your data by removing special characters, converting text to lowercase, introducing hyphens where necessary, and translating umlauts. After working on numerous projects involving such tasks, I have developed a precise and efficient approach that guarantees an impeccable result. Choosing me for this project would mean utilizing the capabilities of someone who not only knows the ins and outs of Excel but also genuinely enjoys parsing through data and turning them into clean and usable forms. Partnering with me guarantees a timely delivery of excellent results that align perfectly with your requirements. Just reach out, and we can get started without any delay!
€19 EUR in 1 day
4.3 (3 reviews)
2.1
2.1
User Avatar
Hi there, I FIT FOR THIS PROJECT. Please review my portfolio for previous experience, https://www.freelancer.com/u/saravananece90?sb=t Special characters of all kinds should be removed (?,ß,&,-,`,™,®, etc...) -YES CAN REMOVE THAT PROPERLY - write everything in lower case - YES I CAN CHANGE LOWER CASE - Replace spaces with hyphens (-). But with ( - ), not (---) may appear but only (-) - YES I CAN REPLACE ONLY WITH HYPHEN(-) - Change umlauts (Ä = Ae, ä=ae, etc...) - YES, I CAN CHAGE AS PER REQUEST. I CAN WORK SAMPLE FOR YOUR REFERENCE. I would do this task perfectly with 100% accuracy and complete on or before the project deadline. Please ping me we will discuss further. I will available for any days to work for your convenience and Finally, I will give dedicative support and you would happy for my work. Thank you, Saravanan
€10 EUR in 1 day
5.0 (4 reviews)
1.8
1.8
User Avatar
Hello, I am Nadiya. I understand what you want. I can solve it today. and I can work right now. please discuss with me via message. please hire me. thank you.
€10 EUR in 1 day
5.0 (1 review)
1.2
1.2
User Avatar
Hello Sir, I have read your instructions and I can do it efficiently according to your requirements. Please give me this project and get 100% extra ordinary work with unlimited revisions even after completion of the work. Will wait for your kind response ? Thank You. Regards, SYEDA NIMRA
€10 EUR in 1 day
5.0 (2 reviews)
1.0
1.0
User Avatar
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am quoting low price since I want to grab opportunity on this platform but work will be 100% accurate. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, accurate data entry. I will be happy to discuss in detail how I am highly suitable for this project. Let me give an example 1st Case: Use Text formula 2nd Case: Use lower case formula 3rd Case: Might need to see data to understand it better Rest can be managed accordingly. Kind Regards Chintan Shah
€15 EUR in 1 day
5.0 (2 reviews)
1.0
1.0
User Avatar
Diese Formel entfernt Sonderzeichen wie ?, ß, &, -, `, ™, ® und ersetzt Umlaute durch ihre jeweiligen Kombinationen. Außerdem wandelt sie den Text in Kleinbuchstaben um und ersetzt Leerzeichen durch Bindestriche. Sie können diese Formel bei Bedarf anpassen, um zusätzliche Sonderzeichen oder Transformationen für Ihren spezifischen Anwendungsfall zu berücksichtigen. =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(A1), "?", ""), "ß", ""), "&", ""), "-", ""), "`", ""), "™", ""), "®", ""), "ä", "ae"), "ö", "oe"), "ü", "ue"), "Ä", "Ae"), "Ö", "Oe"), "Ü", "Ue")
€8 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am a certified and experienced Excel expert. Your Excel formulas applying request is perfectly matching with the specialize service offering in my profile. Please feel free to ask any questions if you have. Thanks!
€8 EUR in 1 day
5.0 (1 review)
0.0
0.0
User Avatar
Hello There, I am very much interested to work on this project. I will follow all then instruction to perform on this project. Best Regards Shameem
€18 EUR in 3 days
5.0 (1 review)
0.0
0.0

About the client

Flag of GERMANY
Roth, Germany
5.0
14
Payment method verified
Member since Feb 20, 2011

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.