Excel Advanced Filter Criteria Use Question Mark Wildcard

preview_player
Показать описание
This video takes a scenario that demonstrates how to use the Ms Excel Advanced Filter to search for rows in a spreadsheet that have a specific number of characters in particular columns. In the Criteria for the filter/query, the demo shows how to use Question Mark character as a wildcard, as well how to punctuate the criteria with an apostrophe to ensure that Ms Excel will treat the filter appropriately rather than as a formula/function that has a syntax error.
Рекомендации по теме