Parse an Excel cell of text

$10-30 USD

Terminado

Publicado

hace más de 6 años

$10-30 USD

Pagado a la entrega

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

ID del proyecto: 15998743

Información sobre el proyecto

12 propuestas

Proyecto remoto

Activo hace 6 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@bilalmaher053

$10 USD en 1 día

4,9

(169 comentarios)

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 en 1 día

4,9

(424 comentarios)

7,5

12 freelancers están ofertando un promedio de $20 USD por este trabajo

@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 en 1 día

5,0

(866 comentarios)

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 en 1 día

5,0

(55 comentarios)

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 en 1 día