Advanced Filter

[Ron]

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]

If criteria range is D12, 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