View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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.