| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract hyperlink string from excel cell | Links and Linking in Excel | |||
| Excel 2000 - How to create an auto search | Excel Discussion (Misc queries) | |||
| Search for a Sheet | Excel Discussion (Misc queries) | |||
| Conditional Formula to search ranges?? | Excel Discussion (Misc queries) | |||
| better search: "make worksheet visible" | Excel Discussion (Misc queries) | |||
Linear Mode
