Filtering By Text Columns

Filter Texts in Excel

In the same manner that numerical filtering is helpful with numbers, filtering by text columns is useful for displaying specific information of textual format.

Filtering names that contain specific syllables may help you recall somebody who’s name you have forgotten. Setting the text filter equal to nothing will let you find those entries that do not have an entry in some category. By using this tool you can easily find people who live on the same street, or if you open up a map and play with the options, even a neighborhood.

When you use filter to select a few names it will allow you to compare those entries while eliminating irrelevant distractions.

If you deal with voluminous list on a daily basis or if you often need to sort out textual entries you should best use this tool.