Find Jobs
Hire Freelancers

Excel formula

€8-30 EUR

Terminado
Publicado hace 3 meses

€8-30 EUR

Pagado a la entrega
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...)
ID del proyecto: 37783841

Información sobre el proyecto

48 propuestas
Proyecto remoto
Activo hace 3 meses

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
€0 EUR en 1 día
4,9 (200 comentarios)
6,5
6,5
48 freelancers están ofertando un promedio de €20 EUR por este trabajo
Avatar del usuario
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 en 1 día
5,0 (518 comentarios)
8,1
8,1
Avatar del usuario
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 en 1 día
4,9 (404 comentarios)
7,5
7,5
Avatar del usuario
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 en 7 días
5,0 (119 comentarios)
7,1
7,1
Avatar del usuario
-------------------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 en 1 día
5,0 (69 comentarios)
5,5
5,5
Avatar del usuario
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 en 1 día
4,7 (46 comentarios)
5,8
5,8
Avatar del usuario
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 en 1 día
5,0 (26 comentarios)
4,5
4,5
Avatar del usuario
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 en 1 día
5,0 (22 comentarios)
4,7
4,7
Avatar del usuario
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 en 1 día
5,0 (53 comentarios)
4,3
4,3
Avatar del usuario
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 en 1 día
5,0 (12 comentarios)
3,6
3,6
Avatar del usuario
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 en 2 días
4,7 (9 comentarios)
3,5
3,5
Avatar del usuario
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 en 1 día
5,0 (9 comentarios)
3,2
3,2
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
2,1
2,1
Avatar del usuario
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 en 1 día
4,3 (3 comentarios)
2,1
2,1
Avatar del usuario
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 en 1 día
5,0 (4 comentarios)
1,8
1,8
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
1,2
1,2
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
1,0
1,0
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
1,0
1,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
0,0
0,0
Avatar del usuario
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 en 3 días
5,0 (1 comentario)
0,0
0,0

Sobre este cliente

Bandera de GERMANY
Roth, Germany
5,0
14
Forma de pago verificada
Miembro desde feb 20, 2011

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.