|Subject:||Search advice appreciated|
|Posted by:||Paul Beaty (Paul.bea…@ntlworld.com)|
|Date:||Tue, 4 May 2004|
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