In Progress

Merge 7 Excel fields into one cell, and convert content to HTML

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.

Skills: CSS, Data Processing, Excel, HTML, Website Design

See more: where to hire employees, when to hire, site design carpet, prim no, looking to hire employees, labor hire, labor for hire, hire day labor, hire company to type, excel company profile, design merge, convert excel to website, convert design to html, cell hire, PRIM, merge data, html to excel, flooring company, excel to html, excel table, data merge, carpet design, looking data conversion projects, html conversion css, excel 2013 formula

About the Employer:
( 31 reviews ) Vancouver, BC, Canada

Project ID: #4553709

Awarded to:

Baxter2008

Hello Kyle I am skilled in Excel VBA, HTML, CSS and PHP. I can quickly set up this macro to generate the combined cell and also add any HTML wrappers. I can deliver the macro within a few hours and am ready to star More

$30 USD in 1 day
(27 Reviews)
4.0

18 freelancers are bidding on average $55 for this job

Teloquence

Consider it done. Check your PM foro my bid details.

$54 USD in 1 day
(326 Reviews)
7.6
best4best

I am an Excel expert. Please share the file with me. I can start the project right away.

$40 USD in 1 day
(140 Reviews)
6.3
sswijaya

Hi let me help you with this - thanks.

$55 USD in 3 days
(67 Reviews)
6.1
rengrish

Hi I have done many such projects.I have 13+ years of experience in Excel.

$40 USD in 1 day
(133 Reviews)
5.9
muzammil21

we do not offer package we offer Only guaranteed results..100% quality work within time limit and ...Read more in PMB

$43 USD in 1 day
(60 Reviews)
6.1
salientcomputer

Hi Please see PMb.

$54 USD in 2 days
(206 Reviews)
6.5
proauthor

Hi, Ready to start your work. Eagerly awaiting for your positive reply. Please check your inbox for further details. Thanks, Shaik.

$40 USD in 0 days
(31 Reviews)
4.7
wasimsohail

Please see PM for more details

$35 USD in 1 day
(31 Reviews)
5.0
MasterExcel

I am Data Entry Expert, MS Word and MS Excel. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high More

$194 USD in 3 days
(11 Reviews)
3.2
hari8184

Hello I have done similar type of work and ready to work on your project immediately. Thanks

$45 USD in 1 day
(2 Reviews)
2.8
HumanCatapult

Hello ! I`m ready to work for you ! Please be kind and check your inbox

$40 USD in 1 day
(3 Reviews)
1.4
vasanthtt

I can do this. I have similar work before.. I am expert in ETL tool like SSIS.

$35 USD in 7 days
(0 Reviews)
0.0
rdelorier

Experienced in thid type of concatenation, ready to complete this for you

$100 USD in 2 days
(0 Reviews)
0.0
ITalendWebAppDev

Hallo kylegruen, As i am Expert in Talend ETL ,i can deliver you the script in single day.

$45 USD in 1 day
(0 Reviews)
0.0
youssefmankari

Hi there, I have experience with parsing Excel files. Could you check your inbox ? Best

$70 USD in 1 day
(0 Reviews)
0.0
raath

Hey , I am ready to do the work . I will complete the project on time.

$35 USD in 1 day
(0 Reviews)
0.0
tyrmit

Hi, I'd love to offer a solution to this project. Refer PM for details :)

$30 USD in 1 day
(0 Reviews)
0.0