Closed

needing excel function

i need a function that remove some parts of a paragraph, its final and the firsts lines

according to this:

1)eliminate its final: given a string, search that string into text and eliminate all the rest from that string.

2)eliminate the firsts lines, given the "n" number of text strings eliminate the first "n" of text rows

----------------------------------------------------------------EXAMPLE----------------------------------------

here the text:

William Shakespeare

From Wikipedia, the free encyclopedia

Shakespeare was born and brought up in Stratford-upon-Avon, Warwickshire.

At the age of 18, he married Anne Hathaway, with whom he had three children: Susanna

and twins Hamnet and Judith. Some time between 1585 and 1592,

he began a successful career in London as an actor, writer, and

part-owner of a playing company called the Lord Chamberlain's Men, later known as the King's Men.

At age 49 around 1613, he appears to have retired to Stratford, where he died three years later.

Few records of Shakespeare's private life survive, which has stimulated considerable speculation

about such matters as his physical appearance, sexuality, religious beliefs and whether the works

attributed to him were written by others.[8][9][10] These speculations are often criticized for failing

to point out the fact that few records survive of most commoners of his period.

1) to eliminate from the substring "strat"

2)to eliminate the first 3 lines with text

the results were:

At the age of 18, he married Anne Hathaway, with whom he had three children: Susanna

and twins Hamnet and Judith. Some time between 1585 and 1592,

he began a successful career in London as an actor, writer, and

part-owner of a playing company called the Lord Chamberlain's Men, later known as the King's Men.

At age 49 around 1613, he appears to have retired to Strat

as you can see i have removed the last part and the first 3 lines with text

Skills: Data Entry, Data Processing, Excel, Research Writing, Visual Basic

See more: excel macro remove suffix string, need remove password protected cell excel 2007, excel function pictures, excel, visual basic for apps, microsoft excel, implement financial excel function rate, excel function list, cut paste vba excel function, excel function extract numbers phone numbers, java call excel function, report excel function oracle apps, ord excel function, excel vba query as400 connection string, excel function maker, excel function creator, lotto excel function, excel function morgage payment, remove parts pictures photoshop, excel function call

About the Employer:
( 26 reviews ) Bogota, Colombia

Project ID: #16619354

30 freelancers are bidding on average $25 for this job

cgullapalli

Hi, I am good at Excel and vba. I have reviewed the instructions and can work on the project. I can eliminate the text required. Hope, the lines are separated by line breaks. It helps me to identify the lines to rem More

$30 USD in 0 days
(674 Reviews)
7.7
schoudhary1553

Hi there..... Warm Greetings We came along with your request for needing excel function and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have profess More

$60 USD in 1 day
(241 Reviews)
7.5
Beacon09

Hi Got the example but need to know the part about n number of text strings. In the example it's only 1 string. I can create a webpage to take input paragraph and achieve the results (as you require) and show ou More

$30 USD in 1 day
(86 Reviews)
6.6
paris2785

Hi, there. My name's Paris Pallas and I'm a very experienced Excel developer. I read your brief and the two steps you mention are among things I work with on a daily basis. I suggest using code which will make your sp More

$25 USD in 0 days
(141 Reviews)
6.6
ksriniravi

Greetings! I understand the requirements and can come up with a function to eliminate first n text rows as well as strip all text to the right of search string. Being a full time freelancer working exclusively on More

$20 USD in 1 day
(145 Reviews)
6.6
aubrey03

This task can be accomplished by creating a macro that will inspect the text line by line and then do some actions as per your requirements. Feel free to contact me so we can discuss the details of this project.

$30 USD in 1 day
(25 Reviews)
4.9
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, More

$30 USD in 1 day
(15 Reviews)
4.1
$30 USD in 1 day
(4 Reviews)
3.8
Jasobeam

I developed a script for excel to do exactly as you want, searching and removing string. it's just a matter of adjusting it to your needs

$30 USD in 2 days
(6 Reviews)
3.4
nguyenanh78

i am very professional on excel. i can do it by VBA code

$20 USD in 1 day
(4 Reviews)
2.1
$25 USD in 3 days
(1 Review)
0.4
lina19

Dear Sir, I have read your project. I was new on this job. And i hope you can give me opportunity for this job. And I will do my best to work it. Relevant Skills and Experience i'm good in excel and word

$30 USD in 2 days
(0 Reviews)
0.0
sro59ed93e151c5b

A proposal has not yet been provided

$15 USD in 2 days
(2 Reviews)
0.0
JermaineChloe

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
LifeCarts

Day 1: I'll send you a spreadsheet which will have a macro to: 1)eliminate its final: given a string, search that string into text and eliminate all the rest from that string. You can have a button and a colored cel More

$30 USD in 3 days
(0 Reviews)
0.0
kholidaliakbar

See my blog [login to view URL] Relevant Skills and Experience Excel, VBA, PHP, R PROGRAMMING

$20 USD in 1 day
(0 Reviews)
0.0
saurabhdubey008

I can do this quickly

$25 USD in 1 day
(0 Reviews)
0.0
BinayakInfotech

Hello Sir/Mam, I have gone through the details of your project and I find it well within our [login to view URL] spare a moment to discuss this project. My recent works: [login to view URL] More

$25 USD in 1 day
(0 Reviews)
0.0
shaileshv1609

A proposal has not yet been provided

$20 USD in 2 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0