Microsoft Excel, convert column of objects to comma separated strings.

$10-30 USD

Completed

Posted

about 3 years ago

$10-30 USD

Paid on delivery

I have a column that contains an object in each row, and that column is titled spokenLanguages: Example: a:3:{ i:0;a:2:{ s:14:"languageAbbrev";s:2:"AA";s:12:"languageName";s:9:"Afrikaans"; } i:1;a:2:{ s:14:"languageAbbrev";s:2:"HB";s:12:"languageName";s:6:"Hebrew"; } i:2;a:2:{ s:14:"languageAbbrev";s:2:"SP";s:12:"languageName";s:7:"Spanish"; } } I want to take that object, and just have a comma separated list of the languageName variable. So in this example, it would be: Afrikaans,Hebrew,Spanish

Excel

Project ID: 29479131

About the project

15 proposals

Remote project

Active 3 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:

@MimiFL

Hello, this is definitely possible. If you can please attach a sheet with more samples so i can see whether this can be solved with formula or with macros. I am available right now. Thanks, Milan

$20 USD in 1 day

5.0

(746 reviews)

7.5

15 freelancers are bidding on average $19 USD for this job

@jiansevillejo

Hi, I understand the requirement. I have an advanced knowledge on Excel's different formulas including pivot charts and visual basic coding. I can help you finish the project as soon as possible.

$12 USD in 1 day

5.0

(97 reviews)

5.6

@mhfsha

Hello Sir/Madam Ready to start now. I can do your project with 100% accuracy. I have reviewed your project brief carefully and would like to assist you with the task.I have 8 years experience of data entry virus task, I want to contribute to your project. I have no project in my hand so that I can start your project right now. If you need any sample let me know.I'll put all my effort ,attention and enthusiasm and hel to achieve your goal. Please check my portfolios and reviews for further verification. I will be looking forward to your quick positive response and if you have any questions, feel free to ask me. Regards, Saanyia.

$15 USD in 1 day

4.8

(123 reviews)

5.5

@mutugijosepj1

Esteemed client I am data analyst with excellent skills in excel. I will help to separate list of the language Name variable as shown in the example you have provided. I assure you of quality work within the set deadline. I offer 24/7 customer support service by being reliable and always available as my previous reviews indicate. Inbox for more details concerning this project. Thanks

$20 USD in 1 day

5.0

(4 reviews)

3.1

@Nouhajab

Helli It is with great pleasure to work on this project. I have worked on similar projects before you can see them in my portfolio and I have experience over 7 years working on Microsoft Office programs and data entry. Also I have certificate from Macquarie University called excel skills for business and. Be sure you will have high quality work and you will be satisfied

$12 USD in 1 day

4.9

(11 reviews)

3.3

@LiAnOr

Hi - I have 15+ years working with excel and excel VBA creating reports, templates and data analysis. You can check my portfolio for sample work. Send me a message if you find me suitable. Thank you!

$20 USD in 1 day