CBlend

I checked the Help area on Microsoft's site and got lots of good information about using advanced filters in Excel. The question I still have is: How do you filter on a text field to find words ending in a letter or combination of letters? For example, I want a list of the records where a particular text field ends in the letters "en".

I tried using "*en", but that also gives you words where the "en" appears in the middle of the word.

Daniel_

assuming that you are only interested in a few known final digits you can use the "right" statement to strip the final text characters.

For example - if your names list is in collumn B, you can put the followig in cell Cn "=RIGHT(Bn,2)" and it will give just the last two letters of Bn.

Got that?

__________________

╔═════════════════════════════════════════╗
Overhead, the Albatross hangs motionless upon the air,
And deep beneath the rolling waves,
In labyrinths of Coral Caves,
The Echo of a distant time
Comes willowing across the sand;
And everthing is Green and Submarine
╚═════════════════════════════════════════╝

CBlend

Found it! The AutoFilter lets you filter on words ending in...