Merge 7 Excel fields into one cell, and convert content to HTML
This project was successfully completed by Baxter2008 for $30 USD in a day.Get free quotes for a project like this
Project Budget$30 - $250 USD
Completed In1 day
This project is to merge 7 separate text fields in an excel table into an list (text field formatted in HTML) stored in new field. If any of the fields are blank, the formula should ignore and move to the next so there are no gaps in the output.
The Sample fields are
COMPANY_NAME | BUSINESS TYPE | LABOR | COMPANY_SIZE | PROJECT SIZE | COMPANY PRIM SIC | COMPANY SEC SIC
Merged list should look like (stored in one cell):
COMPANY NAME (ACME Installers)
* LICENSE (750631)
* LABOR (Non-Union)
* BUSINESS TYPE (Corporation)
* COMPANY_SIZE (5-10 Employees)
* PROJECT SIZE (<$100,000)
* COMPANY PRIMARY SIC (Flooring Installers and Retailers)
* COMPANY SECONDARY SIC (Carpet Installers)
When I apply your formula and conversion to HTML to my data I should get this output:
ACME Installers was added to the [url removed, login to view] directory in 2013. The please confirm the following details when you contact them.
Please note: Installers can claim and update this record by clicking here.
* Company is State Licensed: 1234567
* This business is a Non-Union, Sole Proprietorship
* 5-10 Employees
* We usually take on projects: <$100,000
* Flooring Installers and Retailers, Carpet Installers
I will provide the destination where I am looking to upload this content (profile content on out site) so you can ensure that your html or css will work...
Looking to hire Monday morning for completion within 1 day. $30-$40 is my budget.
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online