Find Jobs
Hire Freelancers

Automatic Selective Extraction of words from Mircrosoft Excel columns

$30-250 USD

Terminado
Publicado hace casi 9 años

$30-250 USD

Pagado a la entrega
Need a way that I could reduce the contents of "RAW DATA" to only 80 characters by deleting specified words I will decide on. If already at 80 characters then that cell should not be changed but rather skipped to the next cell past the 80 characters. EXAMPLE: From list provided (attachment), I would first extract/delete "in" if cell is still past the limit then extract "and" followed by "finish" until all cells are under 80 characters. Something that I currently use in Excel is the REPLACE option but I need to type each word each time....I would rather create a list of words that can be deleted until it reaches the 80 character limit.
ID del proyecto: 8035675

Información sobre el proyecto

36 propuestas
Proyecto remoto
Activo hace 9 años

¿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
Hi, We are experts in excel. If you provide us the key words in order of deletion, we can create a macro which will keep on eliminating words one after the other until total characters excluding " " are lesser than 80. Kindly let us know if you want to consider us for further discussions. Regards, Pal
$30 USD en 1 día
4,9 (33 comentarios)
5,2
5,2
36 freelancers están ofertando un promedio de $87 USD por este trabajo
Avatar del usuario
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
$85 USD en 2 días
5,0 (258 comentarios)
7,6
7,6
Avatar del usuario
A proposal has not yet been provided
$79 USD en 1 día
4,9 (257 comentarios)
7,7
7,7
Avatar del usuario
Consider it done. Check my past reviews for your reference eagerly looking forward for your reply so that I can start with the implementation
$242 USD en 2 días
4,9 (339 comentarios)
7,7
7,7
Avatar del usuario
please check my profile, i've no incomplete project and no bad wording for my work i can give you formulas, that can extract 80 characters, if characters are less than 80 then formula pass that line but also extract same characters in next cell where we are extracting 80 characters but sorry to say, you can't delete your required words, formula only extract 80 characters if you like, i can complete this work within 5 mins lets discuss looking forward thx
$35 USD en 0 día
4,9 (364 comentarios)
7,4
7,4
Avatar del usuario
Dear Concern, I am interested in your job post involving these skills. It says that you are looking for someone who knows English & MS Office, also who is a detail-oriented person. I think that I am the right person for the job. I have very good experience in Data Entry, Data Processing and making spreadsheet. As a data entry operator, I also am detail-oriented. Rest assured all the data will be accurately entered, no more, no less. I am looking forward to discussing with you about this job post. Please feel free to contact me in PM. I am available on line 08 hours a day.
$50 USD en 2 días
4,8 (148 comentarios)
7,5
7,5
Avatar del usuario
Hi, I am an Excel macro expert and would be happy to take on your project. Shall provide you with a Excel macro which will automatically reduce and restrict the characters limit to 80. Let me know. Regards, Arul
$100 USD en 2 días
5,0 (180 comentarios)
7,4
7,4
Avatar del usuario
Hi Sir. I can write a VBA routine for automatic selection of words from Excel as you mentioned in project description. Please discuss so we may continue. Thank you. Usman
$120 USD en 2 días
5,0 (72 comentarios)
6,9
6,9
Avatar del usuario
Hi: Please note that I have 100% completion rate and 5-star feedback on all projects (>60 total completed projects). More than 90% of my completed projects are related to Excel and VBA Script. Please check my profile to confirm the quality of my work. Please connect with me to discuss more
$50 USD en 2 días
4,9 (179 comentarios)
7,1
7,1
Avatar del usuario
Hi, I have lots of experience in excel. Ready to start right now. Refer to Pm so we can discuss. thanks Regards Kool
$111 USD en 1 día
5,0 (139 comentarios)
6,6
6,6
Avatar del usuario
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. We can discuss the budget post discussing the complete requirements. Lets discuss more online on chat. Thanks, Abhinav
$55 USD en 0 día
4,9 (168 comentarios)
6,5
6,5
Avatar del usuario
I can create an easy-to-use template for you. You can input the words-to-be-replaced in a row and then click on button to automatically remove the words to make the length of contents less than 80 characters.
$55 USD en 2 días
5,0 (211 comentarios)
6,6
6,6
Avatar del usuario
Hi! I have experience with a macro in excel. I could fast to do good work .
$33 USD en 1 día
5,0 (42 comentarios)
5,6
5,6
Avatar del usuario
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro (UDF) contained in a separate XLSM file which also contains your list of word to be deleted. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$55 USD en 1 día
4,9 (64 comentarios)
5,7
5,7
Avatar del usuario
Hi, I can suggest the option of macros that I can design for you to acheive this functionlaity. The macro can be executed using a button on the spreadsheet and that will run all the way without any issues. I have worked on excel related projects and know about data automation and macros for working with data in excel. Looking forward to work with you. Regards,
$88 USD en 1 día
5,0 (7 comentarios)
5,2
5,2
Avatar del usuario
Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. You may check my portfolio images to see few pieces of my work. (This is what I do on daily basis). I am a professional and I can do a very good job. Also fast and accurate. Do not hesitate to contact me for further details. Kind Regards, Jon
$80 USD en 4 días
5,0 (37 comentarios)
5,0
5,0
Avatar del usuario
A proposal has not yet been provided
$30 USD en 0 día
4,9 (47 comentarios)
4,5
4,5
Avatar del usuario
Sir/Madam, Good day! I'm a degree holder graduated and I'm an excel expert. I'm also a virtual assistant for more than a year doing excel jobs. Skills in excel: VB in excel, macro, vlook up, automated computation using formulas, HD graphs and figures, etc. You will find me to be motivated and hardworking. If you would like to discuss this further, please do not hesitate to contact me. Thank you.
$88 USD en 3 días
5,0 (6 comentarios)
3,6
3,6
Avatar del usuario
Hi, A total of 10+ years of experience in Macro development and VBA Programmer. My past projects covered projects like Generating multiple reports in different format for billing purpose and estimation tracker, filter test data of various market and compare text files in different formats, converting test files in vbs format. My motto is to maintain good communication with the client, paying close attention to project description of my client and before starting the project I clear all my doubts regarding the projects. Sharing timely status update is also a part of my execution strategy. I am a hard working, professional and detail oriented person. I believe in honesty and always perform high quality of work and provide finish it on time. I would be so much grateful if you provide me with opportunity. Thanks Lal
$55 USD en 2 días
5,0 (8 comentarios)
3,4
3,4
Avatar del usuario
Hello there. The project can be done the following way: 1. The list of words to be removed will be on a separate sheet (or in a separate column). Let's call it "control list" 2. Macro will scan raw data cells and if the length of text in a cell is more that 80 characters, macro will remove the first word which is specified in control list. If the length of text in the cell is still more than 80 chars, then macro will remove the 2nd word specified in control list and so on, until the length is less than 80 chars or until all words specified in control list are removed from raw data cell. 3. If all words specified in control list are removed from raw data cell, but the length is still more than 80 chars, that cell will be highlighted. Please contact me if interested Thanks Kind regards, Alexander
$40 USD en 1 día
5,0 (7 comentarios)
3,1
3,1
Avatar del usuario
Hi, I would love to work on this project. I have 10 years experience managing diverse administrative projects such as this. From an educational stand point I have a Canadian Business Degree with a business analysis certification. I am an advanced Microsoft user, especially excel, word and PowerPoint. I have strong technical and organizational skills which will help be complete your varying tasks quickly and effectively. I am an effective communicator, highly organized and always operate with the highest form of professionalism. I have an advanced understanding of excel and would love to work on this project with you. Please contact with further details if interested. I look forward to your favorable response. Regards Melissa
$88 USD en 3 días
4,6 (4 comentarios)
3,1
3,1

Sobre este cliente

Bandera de UNITED STATES
Moreno Valley, United States
5,0
1
Forma de pago verificada
Miembro desde feb 11, 2015

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.