Segregating a Search String

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HELP!!!

I have a web log that contains URL addresses. I have approximately 32,000
rows. What I need to do is segregate out where the web link contains "OVKEY".
I have approximately 50 of these rows. Is there any way to sweep the Excel
spreadsheet and filter out where the line contains "OVKEY"???

Any help would be GREATLY appreciated!

Thanks!
 
Hi
use 'data - Filter - autofilter' on this column. Click of the drop down
arrow, choose custom and apply a criteria using the operator 'contains'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Segregating Duplicate Transactions 3
Copy and Paste Help 2
Hide rows function 4
Search/Match between 2 x separate Worksheets and populate result in third worksheet 1
Spam, Spam and more Spam 18
how do i write a macro that will add rows into a spreadsheet 5
search text string within array 7
code to remove rows containing a character string 4

Back
Top