Thread: Advanced Filter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Carole O Carole O is offline
external usenet poster
 
Posts: 69
Default Advanced Filter

I'm sure there are shorter ways to do this, but try inserting a column, and
enter and copy down this formula: =RIGHT(A2) where A2 = the first cell of
the particular column you refered to. This will result in the last
(rightmost) letter of A2 - Annn. Then you can sort on that column to get all
cells that end in N. To be safe, copy your database and work with the copy!!

Carole O

"Jean" wrote:

I need to use an Advanced Filter because my database is too long for
AutoFilter. What do I put in the criteria range to find the cells in a
particular column that END in the letter "n"? I tried using *n but my result
showed all names with the letter "n" in it. Thanks.