Tilted Forum Project Discussion Community - View Single Post - [Excel]Advanced filtering to find records ending in 'xxx'

CBlend · 08-14-2005, 05:59 AM

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.

08-14-2005, 05:59 AM	#1 (permalink)
CBlend Junkie Location: Classified	[Excel]Advanced filtering to find records ending in 'xxx' 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.