Specifying the last character for advanced filtering

[Paul Smith]

Dear All

I am trying to filter a database with an advanced filter through the
following criterion:

Town
*l

In order to obtain the lines of the database with town names ended
with 'l', but it does not work. Any ideas?

Thanks in advance,

Paul

 

[Earl Kiosterud]

Paul,

*1 works. It's a good idea to say more than "does not work."

Maybe there's something else awry with your criteria range. Remember that everything in any
row in the criteria range is ANDed, but the rows are ORed. Only one row need be satisfied
for any record to be included.

 

[Paul Smith]

*1 works. It's a good idea to say more than "does not work."

Maybe there's something else awry with your criteria range. Remember that everything in any
row in the criteria range is ANDed, but the rows are ORed. Only one row need be satisfied
for any record to be included.

Thanks, Earl Kiosterud. I will try to be clearer in what follows. Take
the following database:

town numbers
john smith 2500
london 1000

and the criterion

town
*o

When one applies the advanced filter, one gets both lines of the
database. The used criterion should establish that the advanced filter
should show ONLY the lines with towns with names ended with 'o'. Am I
doing something wrong?

Paul

 

[Dave Peterson]

How about:
'=*o

(I used the apostrophe to force the entry to be treated as text. You could also
preformat the cell as text.)

Or
="=*l"
(the formula will evaluate to the correct string.)

 

[Paul Smith]

How about:
'=*o

(I used the apostrophe to force the entry to be treated as text. You could also
preformat the cell as text.)

Or
="=*l"
(the formula will evaluate to the correct string.)

Thanks, Dave. I have just tried the three suggested methods, but none
produces the desired result. Have you also tried them?

Paul

 

[Dave Peterson]

Yep.

The showed the names that ended with L (I used L in my testing).

 

[Earl Kiosterud]

Paul,

First of all, you've bottom posted, where I'd already started with the convention in these
parts of top posting. The threading is getting messy.

I don't see anything ending in o for *o to pull. You have some numbers (ending in zero).
Are they in the same column? Do you mean to pull *0 instead of *o. Or are you trying to
pull anything in column Town that has o anywhere in it?