Đang Thực Hiện

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.

Kỹ năng: CSS, Xử lí dữ liệu, Excel, HTML, Thiết kế trang web

Xem thêm: site design carpet, prim no, looking hire employees, labor hire, hire day labor, hire company type, excel company profile, design merge, prim, merge data, flooring company, data merge, carpet design, looking data conversion projects, html conversion css, excel 2013 formula, convert formatted text html, excel convert formula, blank fields, merge excel project, move data excel, flooring company directory, company claim, html convert table css, excel html cell

Về Bên Thuê:
( 31 nhận xét ) Vancouver, BC, Canada

Mã Dự Án: #4553709

Đã trao cho:

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 Thêm

$30 USD trong 1 ngày
(27 Đánh Giá)
4.0

18 freelancer đang chào giá trung bình $55 cho công việc này

Teloquence

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

$54 USD trong 1 ngày
(326 Đánh Giá)
7.6
best4best

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

$40 USD trong 1 ngày
(140 Đánh Giá)
6.3
sswijaya

Hi let me help you with this - thanks.

$55 USD trong 3 ngày
(67 Đánh Giá)
6.1
rengrish

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

$40 USD trong 1 ngày
(133 Đánh Giá)
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 trong 1 ngày
(60 Đánh Giá)
6.1
salientcomputer

Hi Please see PMb.

$54 USD trong 2 ngày
(206 Đánh Giá)
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 trong 0 ngày
(31 Đánh Giá)
4.7
wasimsohail

Please see PM for more details

$35 USD trong 1 ngày
(31 Đánh Giá)
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 Thêm

$194 USD trong 3 ngày
(11 Đánh Giá)
3.2
hari8184

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

$45 USD trong 1 ngày
(2 Đánh Giá)
2.8
HumanCatapult

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

$40 USD trong 1 ngày
(3 Đánh Giá)
1.4
vasanthtt

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

$35 USD trong 7 ngày
(0 Đánh Giá)
0.0
rdelorier

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

$100 USD trong 2 ngày
(0 Đánh Giá)
0.0
ITalendWebAppDev

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

$45 USD trong 1 ngày
(0 Đánh Giá)
0.0
youssefmankari

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

$70 USD trong 1 ngày
(0 Đánh Giá)
0.0
raath

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

$35 USD trong 1 ngày
(0 Đánh Giá)
0.0
tyrmit

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

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0