Excel Formulas/Function

IN PROGRESS
Bids
17
Avg Bid (USD)
$35
Project Budget (USD)
$30 - $100

Project Description:
**Deliverables: Two Excel Formulas or Excel Functions (Preferred), as described below:

I need two closely related Excel formulas that will take the text data from a spreadsheet and modify it to create a headline of 25 words maximum, as described below.

1) Description of the first formula or function:

This formula will concatenate the product name and the product price (each one in its own cell) to create a headline. The concatenated headline must total no more than 25 characters including spaces. If the total characters would be more than 25, the product name has to be shortened. IMPORTANT: the product name must be shortened to the next whole word (all the product names are multi-word), the formula must not divide words. Any trailing spaces should be removed.

Example: if the product name is "Rubber Baby Buggy Bumpers " and the product price is $18.99, the formula would output "Rubber Baby Buggy $18.99"

2) Description of the first formula or function:

This formula will concatenate the word+space "Buy " and the product name and a period (.), if the product name is thirty characters or less. If the product name has between 30 and 35 characters, the product name alone should be output If the product name has more than 35 characters, it should be shortened to the next whole word (all the product names are multi-word), the formula must not divide words. Any trailing spaces should be removed.

Example: if the product name is "Rubber Baby Buggy Bumper Accessory Set" (38 characters) the formula would output, "Rubber Baby Buggy Bumper Accessory." If the product name were "Rubber Baby Buggy Bumper Accessory" (34 characters) the forumla would output "Rubber Baby Buggy Bumper Accessory" If the product name were "Rubber Baby Buggy" (17 characters), the formula would output "Buy Rubber Baby Buggy."

Skills required:
Engineering, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Project Management, Software Architecture, Software Testing, Word
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.