Excel formula to extract text

$10-30 USD

Completed

Posted

over 3 years ago

$10-30 USD

Paid on delivery

I have cells with this kind of content: a:3:{i:0;s:47:"Know the use of HEC-RAS at the initiation level";i:1;s:79:"Understand the basic principles of hydrology and hydraulics used by the program";i:2;s:52:"Generate flooding models and interpret their results";} I need to extract the text inside the " " So, in a new cell can have this result: Know the use of HEC-RAS at the initiation level Understand the basic principles of hydrology and hydraulics used by the program Generate flooding models and interpret their results

Excel

Excel VBA

Excel Macros

Project ID: 26874837

About the project

9 proposals

Remote project

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

@irfaanmeah

Hey there, I can extract the text for you within the quotes. I can start right away. Please let me know if you would like to discuss the project on a call or have a chat. Thanks, Md Irfaan Meah

$30 USD in 1 day

5.0

(15 reviews)

4.0

9 freelancers are bidding on average $24 USD for this job

@vlayausa

Hello, I am proficient with Excel and VBA and have a lot of experience with making all sorts of macros. I would love to help you with this project, doesn't look very complicated and I think I could have fun working on it. Let's get started with this right now. This is pretty straightforward task, and I can do it as you imagine. I have done many projects similar to this, all with five star feedback, hope will get a chance to work with you too. Please contact me to discuss some more and finish it asap. Thank you, Ivan

$30 USD in 1 day

4.9

(134 reviews)

5.8

@usmnwaraich

Hi there, I can extract you the text from those lines as you need in spreadsheet. I am expert in Excel and data entry. Please send me a message so that we can talk. Thanks

$30 USD in 1 day

5.0

(27 reviews)

5.0

@sdroberts

Hello I'd be happy to help with your issue. I'd solve this by making a vba macro to find pairs of speechmarks and then iterate over the whole string to find the subset of text that you need. Then I'll output this to their own column(s). I have over 10 years experience with excel & vba and I will be able to complete this task accurately and efficiently. Please let me know if you'd like me to pick this work up for you. Kind regards Steve

$30 USD in 2 days

5.0

(8 reviews)

4.0

@themsyterious03

Good Day The formula is ready and I can show you a sample Please Contact me for more discussion Best regards, Ahmed Tarek

$20 USD in 1 day

5.0

(27 reviews)

3.9

@karthik89rec

HI, I know how to do it. We can use a MID function to achieve it. Please leave a message to get this started right away.

$20 USD in 1 day

0.0

(0 reviews)

0.0

@jagtapvishalv

Hi, Specialized with Quality & Unique services. I'm very proficient & have valuable 5 years of experience in MS Excel, Automation, Adv. Excel Macro's and VBA I will do any level of Automation' - Simple -> Complex -> Unimaginable needs. + Guaranteed Satisfaction.

$12 USD in 1 day

0.0

(0 reviews)

0.0

@mwaqas171288

Hello, I am a professional and advanced excel user. In your case the searching parameter should be: Text starting from :" Text ending at "; Functions to be used: SEARCH LEN MID RIGHT LEFT or it can be done programmatically. What suits you? Text can easily be extracted. For each cell, different statements in different cells in the same row. It's just that simple. I can do it in minutes. If you are interested kindly drop me a message. Thanks Waqas

$10 USD in 1 day