How to make boxes of names searchable with only the first and last name written down? Hi everyone, so my issue follows.  I'm trying to make an excel document to sort boxes full of names by last name.  For example, Box 1 has names "Antony - Bob" and Box 2 has "Bob - Carl" etc.  I was wondering if it would be possible to make it so that one could search for a name between Antony and Bob with the search function, but by only providing the first and last people appearing in said box.  So for example, if I wanted to search Bernard, it would bring up Box 1 even though I didn't put Bernard's name there.  I hope this makes sense, any advice would be appreciated.