View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Please let Excel sort by string value within the cell/column.

If the strings aren't too long, you could apply data|Filter|autofilter to that
column.

Then use a custom filter:
contains and your phrase.

Kraig wrote:

I need to search down a column for like phrases within the cells. MS Excel
version 2003 (11.8033.8028), SP2.

----------------
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...el.programming


--

Dave Peterson