Advanced Filter

[ratm]

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

 

[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]

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?&[email protected]

 

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