Overcoming the 255 char limit using autofilter

  • Thread starter Thread starter bigsmokey
  • Start date Start date
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.
 
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
 
Thansk for the reply Dave. I ended up using the windows version of gre
and I was able to get the results I needed
 
Back
Top