Parse an Excel cell of text

$10-30 USD

Completed

Posted

over 6 years ago

$10-30 USD

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 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@bilalmaher053

$10 USD in 1 day

4.9

(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 work quality(100%completion rate).We are very responsible towards our clients. We know our client needs and importance. Skills : Excel, Macros,VB.net, Web scraping, Data entry, Copy typing, Transcription works. With Regards, Bhaskar.

$10 USD in 1 day

4.9

(424 reviews)

7.5

12 freelancers are bidding on average $20 USD 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

5.0

(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

5.0

(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