Đã hoàn thành

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)));"")

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel

Xem nhiều hơn: 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

Về Bên Thuê:
( 1 Nhận xét ) Athens, Greece

ID dự án: #12620458

Được trao cho:


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 Thêm

$15 USD trong 1 ngày
(143 Đánh Giá)

8 freelancer đang chào giá trung bình $32 cho công việc này


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 Thêm

$30 USD trong 1 ngày
(159 Nhận xét)

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 Thêm

$100 USD trong 1 ngày
(23 Nhận xét)

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 Thêm

$10 USD trong 1 ngày
(36 Nhận xét)

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 Thêm

$25 USD trong 1 ngày
(20 Nhận xét)

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 Thêm

$15 USD trong 0 ngày
(27 Nhận xét)
$25 USD trong 1 ngày
(0 Nhận xét)
$25 USD trong 1 ngày
(0 Nhận xét)

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

$33 USD trong 2 ngày
(0 Nhận xét)