Advanced Filter

[ratm]

Is it possible to filter characters such as * and @ using the advanced
filter function? Thanks

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

[Debra Dalgleish]

To filter for an asterisk, use: *~**

To filter for @, leave the heading cell in the criteria area blank. In
the cell below, enter a formula that refers to the first row of data in
the appropriate column, e.g.:
=ISNUMBER(SEARCH("@",A2))

ratm wrote:
> Is it possible to filter characters such as * and @ using the advanced
> filter function? Thanks

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[ratm]

Has nobody answered because they don't know or because they can't be
bothered. I know * is usually a wildcard so its a tricky one, thats why
i have the problem.

[Debra Dalgleish]

I answered your post several hours ago. You can see the response in the
Google newsgroup archive:

http://groups.google.com/groups?&threadm=3FC4A14B.4070501%40contexturesXSPAM.com

[J.E. McGimpsey]

Aside from your post having been answered hours ago (perhaps
ExcelForum didn't pick it up - you *could* bother to use a real
newsreader and connect directly to a newsserver instead of relying
on a web site), your attitude of entitlement stinks.

I don't know much about Excelforum, but on the newsgroups that it
parrots, everyone who participates is a volunteer. You should be
grateful for any reply you get, rather than musing about people who
"can't be bothered".

In my estimation, 95% of the time, when a post goes unanswered, it's
because the message did not give enough intelligible information.
Rarely, nobody knows the answer. Very occasionally, a message slips
through the cracks.

See http://cpearson.com/excel/newposte.htm for tips on how to use
these newsgroups effectively.

In article <ratm....@excelforum-nospam.com>,