Auto Filter

[Ant]

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

 

[bj]

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

 

[Ant]

Sorted, Thanks

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