Closed

Excel Formulas/Function

This project was awarded to zenecisvw for $17 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $100 USD
Total Bids
17
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 $[url removed, login to view], the formula would output "Rubber Baby Buggy $[url removed, login to view]"

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online