Filter with a specific character

[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

 

[Fred Smith]

Yes, you can filter it. What specifically are you looking for?

Regards,
Fred

 

[Dave Peterson]

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