Excel formula to extract text

$10-30 USD

Đã hoàn thành

Đã đăng vào

gần 4 năm trước

$10-30 USD

Thanh toán khi bàn giao

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

Mã dự án: 26874837

Về dự án

9 đề xuất

Dự án từ xa

Hoạt động 4 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

Đã trao cho:

@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 trong 1 ngày

5,0

(15 nhận xét)

4,0

9 freelancer chào giá trung bình $24 USD cho công việc này

@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 trong 1 ngày

4,9

(134 nhận xét)

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 trong 1 ngày

5,0

(27 nhận xét)

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 trong 2 ngày

5,0

(8 nhận xét)

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 trong 1 ngày

5,0

(27 nhận xét)

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 trong 1 ngày

0,0

(0 nhận xét)

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 trong 1 ngày

0,0

(0 nhận xét)

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 trong 1 ngày