View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Filtering long text

Create a helper column

In B1: =LEN(A1)

Drag the Fill Handle in cell B1 to copy down as far as needed, then cutom
AutoFilter in column B for your specific text length


"Havard" wrote:

I have tried to filter for words placed a long way out in a cell text. Excel
2003 do not find the filter (auto filter, custom, contains) word !
Is there a text length limitation for Excel to perform filtering ?
Any suggestion for workaround ?