Find Jobs
Hire Freelancers

Automatic Selective Extraction of words from Mircrosoft Excel columns

$30-250 USD

Завершено
Опублікований almost 9 years ago

$30-250 USD

Оплачується при отриманні
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 проекту: 8035675

Про проект

36 пропозицій(-ї)
Дистанційний проект
Активність 9 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
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 за 1 день
4,9 (33 відгуки(-ів))
5,2
5,2
36 фрілансерів(-и) готові виконати цю роботу у середньому за $87 USD
Аватарка користувача
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 за 2 дні(-в)
5,0 (258 відгуки(-ів))
7,6
7,6
Аватарка користувача
A proposal has not yet been provided
$79 USD за 1 день
4,9 (257 відгуки(-ів))
7,7
7,7
Аватарка користувача
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 за 2 дні(-в)
4,9 (339 відгуки(-ів))
7,7
7,7
Аватарка користувача
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 за 0 день
4,9 (364 відгуки(-ів))
7,4
7,4
Аватарка користувача
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 за 2 дні(-в)
4,8 (148 відгуки(-ів))
7,5
7,5
Аватарка користувача
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 за 2 дні(-в)
5,0 (180 відгуки(-ів))
7,4
7,4
Аватарка користувача
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 за 2 дні(-в)
5,0 (72 відгуки(-ів))
6,9
6,9
Аватарка користувача
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 за 2 дні(-в)
4,9 (179 відгуки(-ів))
7,1
7,1
Аватарка користувача
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 за 1 день
5,0 (139 відгуки(-ів))
6,6
6,6
Аватарка користувача
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 за 0 день
4,9 (168 відгуки(-ів))
6,5
6,5
Аватарка користувача
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 за 2 дні(-в)
5,0 (211 відгуки(-ів))
6,6
6,6
Аватарка користувача
Hi! I have experience with a macro in excel. I could fast to do good work .
$33 USD за 1 день
5,0 (42 відгуки(-ів))
5,6
5,6
Аватарка користувача
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 за 1 день
4,9 (64 відгуки(-ів))
5,7
5,7
Аватарка користувача
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 за 1 день
5,0 (7 відгуки(-ів))
5,2
5,2
Аватарка користувача
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 за 4 дні(-в)
5,0 (37 відгуки(-ів))
5,0
5,0
Аватарка користувача
A proposal has not yet been provided
$30 USD за 0 день
4,9 (47 відгуки(-ів))
4,5
4,5
Аватарка користувача
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 за 3 дні(-в)
5,0 (6 відгуки(-ів))
3,6
3,6
Аватарка користувача
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 за 2 дні(-в)
5,0 (8 відгуки(-ів))
3,4
3,4
Аватарка користувача
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 за 1 день
5,0 (7 відгуки(-ів))
3,1
3,1
Аватарка користувача
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 за 3 дні(-в)
4,6 (4 відгуки(-ів))
3,1
3,1

Про клієнта

Прапор UNITED STATES
Moreno Valley, United States
5,0
1
Спосіб оплати верифіковано
На сайті з лют. 11, 2015

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.