ExcelBanter - Segregating a Search String

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Segregating a Search String (https://www.excelbanter.com/excel-discussion-misc-queries/2412-segregating-search-string.html)

Segregating a Search String

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'

--
Regards
Frank Kabel
Frankfurt, Germany

RTP wrote:
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!