Automatic Selective Extraction of words from Mircrosoft Excel columns

Completed Posted Jul 9, 2015 Paid on delivery
Completed 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.

Data Entry Data Processing Excel

Project ID: #8035675

About the project

36 proposals Remote project Active Jul 13, 2015

Awarded to:

d2imatrix

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. More

$30 USD in 1 day
(33 Reviews)
5.2

36 freelancers are bidding on average $87 for this job

mantislin

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 in 2 days
(258 Reviews)
7.6
zExcel

A proposal has not yet been provided

$79 USD in 1 day
(257 Reviews)
7.7
Teloquence

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 in 2 days
(339 Reviews)
7.7
sy3d

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 More

$35 USD in 0 days
(364 Reviews)
7.4
ZAZwork

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 More

$50 USD in 2 days
(148 Reviews)
7.5
deepbluetech

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

$100 USD in 2 days
(180 Reviews)
7.4
maverick44000

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 in 2 days
(72 Reviews)
6.9
aarifakhtar

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

$50 USD in 2 days
(179 Reviews)
7.1
k00lcaptchrz

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 in 1 day
(139 Reviews)
6.6
avinav606lx

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

$55 USD in 0 days
(168 Reviews)
6.5
best4best

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 in 2 days
(211 Reviews)
6.6
sergpooh

Hi! I have experience with a macro in excel. I could fast to do good work .

$33 USD in 1 day
(42 Reviews)
5.6
nagybatonyi

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

$55 USD in 1 day
(64 Reviews)
5.7
sumeet00

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 wor More

$88 USD in 1 day
(7 Reviews)
5.2
JonNxt

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 More

$80 USD in 4 days
(37 Reviews)
5.0
Ayan

A proposal has not yet been provided

$30 USD in 0 days
(47 Reviews)
4.5
developerguru15

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

$88 USD in 3 days
(6 Reviews)
3.6
lalmansari

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

$55 USD in 2 days
(8 Reviews)
3.4
akrikun

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 More

$40 USD in 1 day
(7 Reviews)
3.1
melissamellor

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

$88 USD in 3 days
(4 Reviews)
3.1