Filter with a specific character

  • Thread starter Thread starter pgarcia
  • Start date Start date
P

pgarcia

Hello all,
I have Excel 2007 and I need to filter a column that has 3 numbers or alph
characters and a "-". Is there a way to do this?
eg:
123-00000
SAN-00000
 
Use the dropdown arrow (after you've applied the filter to that column)
and then use:
Custom
contains
and type the hyphen (or whatever you're looking for)

Be aware that some characters are wildcards to excel:
? represents a single character
* represents any number of characters

If you want to filter to show fields that contain a question mark, ~?
If you want to filter to show fields that contain an asterisk, use ~*

And since ~ is that special "escape" character, you have to use: ~~ to look for
~.
 
Back
Top