Search advice appreciated

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Paul Beaty (Paul.beaty_at_ntlworld.com)
Date: 05/04/04


Date: Tue, 4 May 2004 18:35:11 +0100

I'd be most grateful for somec advice on Excel 2003 & a search facility. I
have an excel file with some 40,000 rows of phrases in column A - 1- 40,000.
When searching phrases with a keyword and using 'find' I can click through
phrase after phrase okay, locating those phrases with the keyword in them.
The question is - Is there a facility within Excel that allows me to search
for phrases with multiple keywords within them, and not just single
keywords. By multiple keywords I mean keywords that do not run
consecutively i.e. searching for a phrase with 'good & day' within them
which is as such - 'It has been a good long day.'

Many thanks for any advice

Paul Beaty



Relevant Pages

  • Re: Focus or not??? - Davidof and Cat esp.
    ... title etc is utalising a threaded phrase ... Am I wrong to go for a few phrases on the main pages? ... The idea for specialized pages on pub walks, real sussex ale, and so ... Create a list of the keywords for each page (there should be however ...
    (alt.internet.search-engines)
  • Re: Website Meta Tags
    ... The trick to keywords and description meta tags is to get the 'right' combination ... keywords or phrases you might use, and do a search for example, on ... are probably 6-8 major search engines so those are the ones you should focus on. ...
    (microsoft.public.frontpage.client)
  • Re: Search advice appreciated
    ... Hi, Paul. ... locating those phrases with the keyword in them. ... > for phrases with multiple keywords within them, ... By multiple keywords I mean keywords that do not run ...
    (microsoft.public.excel)
  • Re: Bending a graphics bar into a circle
    ... I've Googled this to death and all the keywords and phrases I try fail to supply the needed technique. ...
    (comp.graphics.apps.photoshop)
  • Re: FreeTextTable on image column of document metadata
    ... If you're using SQL Server 7.0, you are limited to extracting the text from ... store binary files (MS word, MS Excel, Adobe PDF files, etc.) in an column ... Can I assume that if you search on keywords that you know to be in the body ... contains that keyword returned in your CONTAINS or FREETEXT query? ...
    (microsoft.public.sqlserver.fulltext)