The other day at work I was presented with a list of physicians for whom I needed to find some information. This was necessary only for physicians with ID numbers over 3 characters long.
Rather than sort the list by ID number, delete records under 1,000, and re-sort alphabetically, LEN() returned the number of characters quickly. From here I was able to filter the data to see only entries with 4 or more characters in the ID number. This way I was able to avoid tampering with the original data set by not deleting, resorting, etc.
Very cool, easy trick — always more of these to learn in Excel!
Be sure to subscribe to the newsletter for more Excel tips and tricks.