How to filter information in Excel tables

1. If the number of building names is certain, filter-advanced filter-select formula limit-enter the formula "mid (cell name of building name, 1, length of building name)"-OK.

2. If the length of the building name is different (there is an obvious mark between the building name and the building number, such as "-"), the formula is changed to "left (the name of the unit where the building name is located, search ("-",the name of the unit where the building name is located)-1)"

Sure!

All right!