View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Marc[_25_] Marc[_25_] is offline
external usenet poster
 
Posts: 11
Default Filter numbers with textbox using 123132*

Hi Dave,

Thanks for the suggestions. I figured it out as I tired what wrote in
the last message.

I set a cell to contain the number of characters in a cell (z3)
and then used =left(B6,$Z$3) in a dummy column and used autofilter on
that column.

Cheers

Marc