Find String Length with LEN()

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.

LEN

Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: