Do some Excel Work

I have an excel function that works fine when i try it to one cell (B1). The problem is that i want this function to search all B column because my text has millions of characters and when i paste it to B1 cell, excel automatically splits the text from B1 cell to B35000 cell. I tried to change the B1 parameter to something like B:B or B1:B35000 but i have no result. Does anyone know how to make this happen? My function is the following:

=IF(ISNUMBER(SEARCH(">"&A1; B1));MID(B1;SEARCH(">"&A1; B1);IF(ISNUMBER(SEARCH(">"; B1;SEARCH(">"&A1; B1)+1));SEARCH(">"; B1;SEARCH(">"&A1; B1)+1)-SEARCH(">"&A1; B1);LEN(B1)-SEARCH(">"&A1; B1)));"")

Квалификация: Ввод данных, Обработка данных, Excel

Показать больше macros work excel internet, excel vba com send parameter word macro, macro dont work excel 2000, freelance work excel vba, track work excel, macros written excel 2000 work excel 2007, contract work excel access, excel 2000 macros work excel 2007, article submission work excel, show project work excel, work excel file, contract work excel, online contract work excel, data entry work excel, work excel database, surf internet work excel

О работодателе:
( 1 отзыв ) Athens, Greece

ID проекта: #12620458



Hello SAKISSRRIS, I have read your project description clearly and I understood your requirement. It is very simple task and agree that can complete task with high quality and [login to view URL] our reviews to confirm Больше

$15 USD за 1 день
(143 отзывов(-а))

8 фрилансеров(-а) в среднем готовы выполнить эту работу за $32


Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 300 projects. Plea Больше

$30 USD за 1 день
(159 отзывов(-а))

Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have d Больше

$100 USD за 1 день
(23 отзывов(-а))

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y Больше

$10 USD за 1 день
(36 отзывов(-а))

Hello I am Asaduzzaman Apu I see your project and i do it as your acceptation.I have 3 years experience to work in a any kind data process Web Scraping, Web Search, Excel,Affiliate Marketing, Email Marketing, Internet Больше

$25 USD за 1 день
(20 отзывов(-а))

Hi I have gone through the project requirements. I have 6 years of experience with excel reporting and excel VBA macro. I have completed very similar projects in the past. Please let me know when we shall s Больше

$15 USD за 0 дней(-я)
(27 отзывов(-а))
$25 USD за 1 день
(0 отзывов(-а))
$25 USD за 1 день
(0 отзывов(-а))

I have a great speed in excel and I will complete your project as soon as possible

$33 USD за 2 дней(-я)
(0 отзывов(-а))