I am filtering a list of 400 text strings ( I have posted a subset below), some of which have anywhere from 1 to 4 asterisks.
I know how to use the ~ to filter (both advanced filter and auto filter) for ANY number of asterisks: *~*. I also know how to use the ~ to advanced filter for more than an X number
of asterisks: If I want to filter for 2 or more asterisks, I type:*~*~*
However, I don't know how to filter for a SPECIFIC number of asterisks--how would I filter for text containing just 2 or just 3 or just 4 asterisks?
I have pasted below the list that I am trying to filter:
Decisions
[TABLE="width: 242"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Alpine **[/TD]
[/TR]
[TR]
[TD]Alpine 0609[/TD]
[/TR]
[TR]
[TD]Amador 1594[/TD]
[/TR]
[TR]
[TD]Butte ****[/TD]
[/TR]
[TR]
[TD]Calaveras 0000[/TD]
[/TR]
[TR]
[TD]Contra Costa 1629[/TD]
[/TR]
[TR]
[TD]Del Norte **[/TD]
[/TR]
[TR]
[TD]Del Norte 1382[/TD]
[/TR]
[TR]
[TD]Fresno ***[/TD]
[/TR]
[TR]
[TD]Fresno 0935[/TD]
[/TR]
[TR]
[TD]Humboldt **[/TD]
[/TR]
[TR]
[TD]Inyo 0694[/TD]
[/TR]
[TR]
[TD]Kern ***[/TD]
[/TR]
[TR]
[TD]Los Angeles *A28222[/TD]
[/TR]
[TR]
[TD]Madera ***[/TD]
[/TR]
[TR]
[TD]Mendocino *A26951, A27929[/TD]
[/TR]
</tbody>[/TABLE]
I know how to use the ~ to filter (both advanced filter and auto filter) for ANY number of asterisks: *~*. I also know how to use the ~ to advanced filter for more than an X number
of asterisks: If I want to filter for 2 or more asterisks, I type:*~*~*
However, I don't know how to filter for a SPECIFIC number of asterisks--how would I filter for text containing just 2 or just 3 or just 4 asterisks?
I have pasted below the list that I am trying to filter:
Decisions
[TABLE="width: 242"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Alpine **[/TD]
[/TR]
[TR]
[TD]Alpine 0609[/TD]
[/TR]
[TR]
[TD]Amador 1594[/TD]
[/TR]
[TR]
[TD]Butte ****[/TD]
[/TR]
[TR]
[TD]Calaveras 0000[/TD]
[/TR]
[TR]
[TD]Contra Costa 1629[/TD]
[/TR]
[TR]
[TD]Del Norte **[/TD]
[/TR]
[TR]
[TD]Del Norte 1382[/TD]
[/TR]
[TR]
[TD]Fresno ***[/TD]
[/TR]
[TR]
[TD]Fresno 0935[/TD]
[/TR]
[TR]
[TD]Humboldt **[/TD]
[/TR]
[TR]
[TD]Inyo 0694[/TD]
[/TR]
[TR]
[TD]Kern ***[/TD]
[/TR]
[TR]
[TD]Los Angeles *A28222[/TD]
[/TR]
[TR]
[TD]Madera ***[/TD]
[/TR]
[TR]
[TD]Mendocino *A26951, A27929[/TD]
[/TR]
</tbody>[/TABLE]