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.
|