Find Jobs
Hire Freelancers

Automatic Selective Extraction of words from Mircrosoft Excel columns

$30-250 USD

完了済み
投稿日: 9年近く前

$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年前

お金を稼ぎたいですか?

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
お支払い方法確認済み
メンバー登録日:2月 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)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。