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

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

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

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.
--
Brevity is the soul of wit.


"bstutsman" wrote:

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