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.
|