Excel - let search for more than one disconnected word in a cell
 

MS Excel does not let me find for multiple words at different locations in a
sentence. For example - I cannot use the "Find" function for a cell that
contains two or more disconnected words like "Sale" and "June" that appear in
a cell that reads "The sale for the month of June was xxxxx.....".
I am sure a lot of users would love this feature in Excel, just as they all
can use the search engines like Google or Yahoo.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Excel - let search for more than one disconnected word in a cell
 

Edit / find sale*june

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Milinds" wrote in message
...
MS Excel does not let me find for multiple words at different locations in
a
sentence. For example - I cannot use the "Find" function for a cell that
contains two or more disconnected words like "Sale" and "June" that appear
in
a cell that reads "The sale for the month of June was xxxxx.....".
I am sure a lot of users would love this feature in Excel, just as they
all
can use the search engines like Google or Yahoo.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions