Parse an Excel cell of text

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

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.

Excel Excel VBA Visual Basic

Project ID: #15998743

About the project

12 proposals Remote project Active 6 years ago

Awarded to:

$10 USD in 1 day
(169 Reviews)
6.5
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 More

$10 USD in 1 day
(424 Reviews)
7.5

12 freelancers are bidding on average $20 for this job

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 in 1 day
(866 Reviews)
8.0
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 in 1 day
(55 Reviews)
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

$20 USD in 1 day
(34 Reviews)
5.6
abdulkaderzilani

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

$20 USD in 1 day
(0 Reviews)
0.0
JMuhia

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
karimi831

i can do this job

$15 USD in 1 day
(0 Reviews)
0.0