How do I filter for cells that contain 3 or less characters

[bstutsman]

The cells contain up to seven characters. I want to see only those cells
which contain three characters or less.

 

[Dave F]

Use Advanced Filter and in the parameters use the formula =LEN(A1)<4

For more info on advanced filter, see:
http://www.contextures.com/xladvfilter02.html

Adjust the cell reference to suit your needs.