Completed

Parse an Excel cell of text

I have an Excel spreadsheet that has names that are not a font color black. I need a function to pull out the colored text with a comma between the values. See the attached file for examples. I have a function that will pull out the text but I'm having trouble with adding a comma. Not all names are in a colored font. Row 1 will be Benevolenskaya EV, Frolov MV Row 2 will be Rehman J, Benevolenskaya EV. If the name is in a black font it is skipped. Single names can have a comma at the end.

Taidot: Excel, Excel VBA, Visual Basic

Näytä lisää: google docs spreadsheet cell text limit, php ftp parse excel spreadsheet, translate cell text japanese english excel, vba excel cell text processing, importing text data excel cell macro, excel vba export cell text, excel copy paste postal address single cell, macro excel cell contents spreadsheet, parse text file spreadsheet, parse excel file, excel cell browser, excel cell contents, excel database vfront end, excel sorting text files, excel macro front end creation, excel unicode text, excel search front end, reading excel file text mining, excel convert text numbers commas, excel data front end

Tietoa työnantajasta:
( 114 arvostelua ) Charleston, United States

Projektin tunnus: #15998743

Myönnetty käyttäjälle:

$10 USD 1 päivässä
(88 Arvostelua)
5.4
SBITServices

Hello , I have done similar project to previous client. I have 5 years experience and completed 500 projects till now. I agree that can complete task with high quality and [login to view URL] our reviews to confirm our Lisää

$10 USD 1 päivässä
(260 Arvostelua)
7.1

16 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

cgullapalli

Hi, I am good at Excel and vba. I have reviewed the excel file. I can add comma between each name. Looking forward to work on the project. -Chandra

$34 USD 1 päivässä
(636 arvostelua)
7.7
$15 USD 0 päivässä
(354 arvostelua)
6.6
emamulbd

Hi there, I have good experience in Excel and VBA. I hope I'm perfect for this job. I'm ready to test. Thanks Emamul H.

$25 USD 1 päivässä
(30 arvostelua)
5.5
osmemon

I have 7 years of experience in Excel and VBA with 100% client satisfaction history. I can extract color values by developing custom function. See my profile for client reviews. Looking for your response

$20 USD 1 päivässä
(34 arvostelua)
5.6
JackieXu

hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard.

$25 USD 1 päivässä
(21 arvostelua)
4.4
$20 USD 1 päivässä
(9 arvostelua)
4.1
$25 USD 1 päivässä
(2 arvostelua)
2.6
$20 USD 1 päivässä
(1 arvostelu)
1.7
abdulkaderzilani

Diear sir I see your attach file. (1184). i can do it. thanks Lisää

$20 USD 1 päivässä
(0 arvostelua)
0.0
bison2018

I am an experienced and motivated Network Administrator accomplished in delivering secure resilient systems on time and budget to meet business needs.

$25 USD 1 päivässä
(0 arvostelua)
0.0
sinankhan969

Hi there! Allow me to handle this project, i will complete this project before the given deadline. I have experience of 3 years of writing, you will love to continue with me after this job. Thanks,

$20 USD 1 päivässä
(0 arvostelua)
0.0
JMuhia

A proposal has not yet been provided

$25 USD 1 päivässä
(0 arvostelua)
0.0
karimi831

i can do this job

$15 USD 1 päivässä
(0 arvostelua)
0.0
attiqxainder

Hi there, Allow me to handle this project. I will provide the project in the given deadline and I saw the file. It contains more than 1000+ entries but would love to take this project. I have three years of excel exper Lisää

$15 USD 1 päivässä
(0 arvostelua)
0.0