Terminé

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.

Compétences : Excel, Excel VBA, Visual Basic

en voir plus : 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

Concernant l'employeur :
( 169 commentaires ) Charleston, United States

Nº du projet : #15998743

Décerné à:

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(155 Commentaires)
6.3
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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(408 Commentaires)
7.4

13 freelance font une offre moyenne de $20 pour ce travail

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(834 Commentaires)
7.9
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(465 Commentaires)
6.9
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(53 Commentaires)
5.9
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(34 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(38 Commentaires)
4.9
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(14 Commentaires)
4.7
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(12 Commentaires)
4.1
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(5 Commentaires)
2.2
abdulkaderzilani

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
JMuhia

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
karimi831

i can do this job

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0