Advanced Filter

Ron · Aug 15, 2003

Hello,

Does any one know how to use the Advanced Filter to
extract only those cells in the column below that contain
at least one character "_"

12
44_6_4
3_2
5555

In the data above I would want to see the Advanced Filter
output be the two strings 44_6_4 and 3_2

I don't know if there is any way in the criteria field to
accomplish this.

thanks for any help

Ron

Bob Umlas · Aug 15, 2003

If criteria range is D1

2, leave D1 empty, put this in D2 (assumes your
range is A1:A100 with A1 having a heading of some sort)...
=NOT(ISERROR(FIND("_",A2)))

A live, online Excel Master Class is starting in September (which I'm
teaching).
For details, please follow this link:

http://www.iil.com/str_link_all_results.asp?select_cartid=395

Bob Umlas
Excel MVP