Using wildcards when filtering - anything exist to signify a number?

[jlax34]

I know when you are using a filter, you can use a * to represent a wildcard. What I am curious about, is whether there is something that can be put in that would signify a wildcard, but also specify that the wildcard HAD to be a number.

For example, I have a spreadsheet that has a bunch of movies in the list including TV series. The TV series are all designated at the end as "S1", "S2", "S3" etc... to signify the various seasons. If I wanted to apply the filter and bring back ONLY titles that were part of a season, I could put in the wildcard "S*", but that would also bring back pretty much anything that had an "S" in the title as well. I did try using "S#" on a whim to see if that would work as a number wildcard, but not the case. Anyone know of anything I can use?

[Pete_UK]

If your numbers can only be 1 digit, then try * S?, if 2 digits then try * S??. Note the space after the asterisk, so the title would have to end with S followed by 1 or 2 characters (digits).

Hope this helps.

Pete

[martindwilson]

what is the exact layout?
Attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

[jlax34]

It does allow me to apply a filter, but still doesn't quite work. I think part of the issue is that I need to use "Contains" rather than "ends with". There are often times that there may be something after an "S1" or something.

[martindwilson]

see post #3

[jlax34]

There is no layout in particular to look at. All I am doing it trying to apply a filter on a single column. The spreadsheet could be 50 rows long or 1..it makes no difference.

You can picture the list below as a spreadsheet and I want to apply a filter so that all of the titles that are part of a season (so anything below that contains "S1" or "S6" or whatever and ignore everything else. When filtering, I can put in "Contains S*" and limit it somewhat, but that also brings back any title with an "S" in it. Just want to know if there is something I can put in place of the * that would signify it is still a wildcard, but ONLY an integer. Not looking to do anything complicated with formulas or macros. If I can't do it with a filter, then it isn't that important.


Title
AMERICAN S1 V1
AMERICAN S2 V2
AMERICAN S6 V3
ANGER MANAGEMENT S8
BOARDWALK EMPIRE S3 V1
BOARDWALK EMPIRE S2 V2
BOARDWALK EMPIRE S1 V3
100 GHOST STREET RETURN OF RIC
10000 BC
12 ROUNDS
127 HOURS
13 ASSASSINS
3 10 TO YUMA (WS)
30 DAYS OF NIGHT
30 DAYS OF NIGHT DARK DAYS
30 MINUTES OR LESS

[martindwilson]

is all of that in one cell per entry? Attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

[Pete_UK]

Try it with Contains:

<space>S?<space>

It won't return Anger Management S8 as that appears at the end of the string, but it should get the others.

Hope this helps.

Pete

[Pete_UK]

To make it more robust in the future, maybe you should put the series numbers in square brackets, say, like this - [S1], [S2] etc. - so it will be easier to search for [S. You could do a similar thing for your V numbers. It occurs to me that if you had the word " so " in one of your titles then the sequence in post #8 would list that title.

Hope this helps.

Pete