Filtering a table by a text range

I would like to filter a table or list via a text range. For example...I would like to know all the people whose last name are in the range, A*...Bee*. Is this possible?