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.