Excel formula to extract text

$10-30 USD

完了済み

投稿日:

4年近く前

$10-30 USD

完了時にお支払い

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

プロジェクト ID: 26874837

プロジェクトについて

9個の提案

リモートプロジェクト

アクティブ 4年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

アワード者:

@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 1日以内

5.0

(15 レビュー)

4.0

この仕事に9人のフリーランサーが、平均$24 USDで入札しています

@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 1日以内

4.9

(134 レビュー)

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 1日以内

5.0

(27 レビュー)

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 2日以内

5.0

(8 レビュー)

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 1日以内

5.0

(27 レビュー)

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 1日以内

0.0

(0 レビュー)

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 1日以内

0.0

(0 レビュー)

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 1日以内