Automatic Selective Extraction of words from Mircrosoft Excel columns
$30-250 USD
Paid on delivery
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.
Project ID: #8035675
About the project
36 freelancers are bidding on average $87 for this job
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
Consider it done. Check my past reviews for your reference eagerly looking forward for your reply so that I can start with the implementation
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, Aru More
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
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 t More
Hi, I have lots of experience in excel. Ready to start right now. Refer to Pm so we can discuss. thanks Regards Kool
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 ou More
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.
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) c More
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 us More
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, f More
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 analy More