I am performing an advanced filter in Excel. One of my list fields is Name.
When trying to display all of the records that end in with a specific
character (lets say 'e'), I use the following criteria:
*e
When I apply the advanced filter, I am getting all the records that have an
'e' anywhere in the name field.
I'm pretty sure I'm using the wildcard correctly. Enough to drive you nuts .
. .
Thanks in advance,
Randy
In the criteria cell, enter: ="=*e"
> I am performing an advanced filter in Excel. One of my list fields is Name.
> When trying to display all of the records that end in with a specific
[quoted text clipped - 11 lines]
>
> Randy

Signature
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
Randolph Pugh - 09 Apr 2008 04:28 GMT
Thank you Debra! Your website just made my favorites list.
I'm going to find out why that works before I die.
Randy
> In the criteria cell, enter: ="=*e"
>
[quoted text clipped - 13 lines]
>>
>> Randy
spacia - 09 Apr 2008 04:35 GMT
Bravo! I have been trying to resolve the same issue for three days.
Thank you.
Chris
> In the criteria cell, enter: ="=*e"
>
[quoted text clipped - 19 lines]
>
> - Show quoted text -