Advance Filter help

can you upload an example sheet?

You can use *RTN* in the text filter. That will find it within the value.

But, if you need 3 text strings to be filtered i'm pretty sure you will need to add a column to create another flag. I can only add two values to the built in text filter.

Upload, and it will be easy to show you what to do :D

Insert a new column and assuming the second row is your first entry type:

=OR(ISNUMBER(FIND("RTN",L2)),ISNUMBER(FIND("PO BOX",L2)),ISNUMBER(FIND("MAIL RETURN",L2)))

then drag down to populate the column. You can then apply a filter on this column for all values that are FALSE.

Hope this helps

EDIT: I'm not sure if this works in 2003, if not have a go at using the OR, ISNUMBER and FIND functions on their own to see what doesn't work and I will see if there is another way (is someone else doesn't have a better method)

Incluse within the OR:

ISNUMBER(VALUE(LEFT(L2,1)))

ie. =OR(ISNUMBER(FIND("RTN",L2)),ISNUMBER(FIND("PO BOX",L2)),ISNUMBER(FIND("MAIL RETURN",L2)),ISNUMBER(VALUE(LEFT(L2,1))))

as long as VALUE is compatible with 2003 you should be OK.