Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter with a specific character
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter with a specific character
Yes, you can filter it. What specifically are you looking for?
Regards, Fred "pgarcia" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter with a specific character
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 ~. pgarcia wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Instances of a Specific Character | Excel Discussion (Misc queries) | |||
Counting a Specific Character | Excel Discussion (Misc queries) | |||
How I find specific character?? | Excel Worksheet Functions | |||
Add number from a cell that contains a specific character | Excel Worksheet Functions | |||
lookup specific character place | Excel Worksheet Functions |