Thread: Auto Filter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Auto Filter

your best bet is to use a helper column with LEN() and dot eht auto filter on
this column.

"Ant" wrote:

Can I enter something into the custom section of an auto fitter so that it
looks for lines that just have one character e.g. an initial as apposed to a
name?



Thanks