Overcoming the 255 char limit using autofilter

B

bigsmokey

I am trying to autofilter a csv file that has over 255 char in a field.
Is there a reg hack/workaround to be able to filter this field.
 
D

Dave Peterson

Not quite a hack, but if you're looking for a substring within that long string
(contains in your autofilter), you could use a helper column with a formula
like:

=countif(a1,"*hi there*")>0

Then you can filter on that column to show/hide True or False.


Debra Dalgleish uses a different formula to get the same type of result. You
can see her suggestion at:

http://www.contextures.com/xlautofilter02.html#String
 
B

bigsmokey

Thansk for the reply Dave. I ended up using the windows version of gre
and I was able to get the results I needed
 
Top