View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Finding cells with a specific number of characters

If you want to use Advanced Filter...here's how:

Assuming your list begins in A6, with the column heading in A5
Example:
A5: TextField
A6: Some text of variable length that may or may not exceed 250 chars
etc

Then:
A1: LenTest
A2: =LEN(A6)250

Next: Select your text values A5 through the bottom of the list
<Data<Filter<Advanced Filter
Uncheck: Copy to another location
Uncheck: Unique records only
List Range: (already selected)
Criterial Range: $A$1:$A$2
Click the [OK] button

You should now see only cells that are longer than 250 chars.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Kamran" wrote:

I'm trying to find all the cells in a column that have more than 250
characters. I've tried using DataFilterAdvanced, but haven't been able to
figure it out. I appreciate any help.