2003 advanced filter 255 limit

[sadams1]

Have cells more than 255 characters, is it possible to use the advanced filter to search through them? Tried wildcards, no luck. Went through previous posts & found only one but that didn't seem to work (?)

 

[mikerickson]

What condition are you testing with AdvancedFilter?
Have you tried using formulas instead of Headers in the Criteria range

e.g. instead of
Name
Smith

use
[blank]
=LEFT(A2,5)="Smith"

 

[sadams1]

It's pretty simple:

HEADER
*stuff*

the idea is to run through a pile of characters in a cell & yank out some "stuff"
works great if 255 characters or less

=================

you suggest:

[blank]
=LEFT(A2,5)="stuff"

what should be in "A2"

 

[mikerickson]

In my example A:A was the column with the Name header.
("Name" in A1, data in A2 and downward)

Help topic "Filter for conditions created as the result of a formula" is where I was headed.

For simple criteria, formulas could duplicate the effect of header based criterias.

 

[lenze]

Maybe you could use per Mike's example
=ISNUMBER(FIND,"stuff",A2))

lenze

 

[sadams1]

Thanks guys for the help...any chance I could send a small file to show exactly what's going on?