In Progress

Excel Formulas/Function

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

Skills: Engineering, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Project Management, Software Architecture, Software Testing, Word

See more: buy buy baby, less than excel, excel spreadsheet formula, excel less than, description of product management, rubber, excel function, Excel formulas, excel formula, excel $2-30, concatenate, excel formula spreadsheet spreadsheet, cell names, data set formula, example baby product description, excel cell, text function excel, concatenate php, maximum characters spaces, excel formula description, spreadsheet excel word, price formula, create excel formulas, functions spreadsheet, rubber product

About the Employer:
( 5 reviews ) Bangkok, Thailand

Project ID: #3472350

Awarded to:

zenecisvw

See private message.

$17 USD in 2 days
(33 Reviews)
5.0

17 freelancers are bidding on average $35 for this job

fastudiovw

See private message.

$17 USD in 2 days
(731 Reviews)
7.5
pShankar2

See private message.

$85 USD in 2 days
(409 Reviews)
7.1
shikhamehta

See private message.

$17 USD in 2 days
(210 Reviews)
6.9
slavisatosic

See private message.

$41.65 USD in 2 days
(113 Reviews)
6.0
geckogon

See private message.

$8.5 USD in 2 days
(16 Reviews)
5.4
ricks7

See private message.

$21.25 USD in 2 days
(94 Reviews)
5.3
nafarin

See private message.

$40.8 USD in 2 days
(83 Reviews)
5.2
mahfuzmurshed

See private message.

$42.5 USD in 2 days
(74 Reviews)
4.6
kalietvw

See private message.

$42.5 USD in 2 days
(13 Reviews)
3.8
JackWorm

See private message.

$4.25 USD in 2 days
(9 Reviews)
3.7
Kharys

See private message.

$85 USD in 2 days
(3 Reviews)
2.6
Abikris

See private message.

$10.2 USD in 2 days
(5 Reviews)
2.5
tusharvb7

See private message.

$68 USD in 2 days
(5 Reviews)
2.5
PDguru

See private message.

$17 USD in 2 days
(1 Review)
0.5
investOmatics

See private message.

$63.75 USD in 2 days
(0 Reviews)
0.0
yasoovw

See private message.

$8.5 USD in 2 days
(0 Reviews)
0.0