İptal Edildi

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

Beceriler: Veri Girişi, Veri İşleme, Excel, Araştırma Yazarlığı, Visual Basic

Daha fazlasını gör: basic excel functions list, what are the main functions of ms excel?, basic functions of ms excel, complex excel spreadsheet examples, excel functions with examples, excel functions, common excel functions, basic excel functions pdf, excel function pictures, 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

İşveren Hakkında:
( 0 değerlendirme ) jenin, Palestinian Territory

Proje NO: #16719289

Bu iş için 13 freelancer ortalamada $421 teklif veriyor

in %bids___i_period_sub_35% gün içinde333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(56 Değerlendirme)
5.8
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll code this your current M Daha Fazla

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(29 Değerlendirme)
5.7
scorpionobaid01

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)
4.0
supergana

Hi - I am an IT professional with 2 decades of experience. I have 2 patents in US. As far as excel is concerned i am quite well versed with the technology which i have mastered over 2 decades. I can handle simple e Daha Fazla

in %bids___i_period_sub_35% gün içinde443%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(16 Değerlendirme)
4.0
in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
1.3
karanveerchouhan

I'm Not gonna do it with visual basics... But, I can make functions for your need in CMD/Batch/Notepad script. And, you can remove and modify as much sub-strings from the paragraphs as you want from those functions....

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
Geet7509

Thnks Relevant Skills and Experience I dont have any experience of working with you... I need an experience

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
sarafmandar09

hi, please give me a chance I can really do this. I am really very excited to solve this problem please don't worry about the money we will discuss. awaiting for your reply.

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde370%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
Rahul99090

I am good exprience of excel work .i am last 3 year working in excel work.

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde305%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0