Is there a way to do a search for all fields that contain more than 1000 alphanumeric characters?
B Brandon May 19, 2008 #1 Is there a way to do a search for all fields that contain more than 1000 alphanumeric characters?
B Brandon May 19, 2008 #2 Found it . . . Insert a formula like =Len(a1) in a separate column and then sort by that column to see the characters.
Found it . . . Insert a formula like =Len(a1) in a separate column and then sort by that column to see the characters.
P Pete_UK May 19, 2008 #3 What do you mean by "search"? LEN(A1) will give you the number of characters in A1, so you could put this formula in a helper column: =IF(LEN(A1)>1000,"Yes","") and copy down. You can then apply autofilter to this column and select Yes from the filter pull-down. Hope this helps. Pete
What do you mean by "search"? LEN(A1) will give you the number of characters in A1, so you could put this formula in a helper column: =IF(LEN(A1)>1000,"Yes","") and copy down. You can then apply autofilter to this column and select Yes from the filter pull-down. Hope this helps. Pete
