Is it possible to filter characters such as * and @ using the advance
filter function? Thank

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

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

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.


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

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


http://groups.google.com/groups?&thr...turesXSPAM.com

ratm wrote:
> 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.
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>


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

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 <(E-Mail Removed)>,
ratm <(E-Mail Removed)> wrote:

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