LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
dtencza
 
Posts: n/a
Default Advanced filtering in Excel to find records ending in xxx?

I checked the Help area 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find and replace path name in Excel cells containing hyperlink leoe Excel Discussion (Misc queries) 1 August 9th 05 08:57 PM
display count/results of filtering Excel in status bar JayDax Excel Discussion (Misc queries) 2 July 21st 05 11:41 PM
where Can I find the download for excel viewer for windows me Stevens Excel Discussion (Misc queries) 1 February 14th 05 08:57 PM
Where can I find advanced info on Excel Charts? curtis_tx Charts and Charting in Excel 3 December 18th 04 08:05 PM
Duplicate records in Excel Sheidsa Excel Discussion (Misc queries) 1 November 30th 04 12:23 AM


All times are GMT +1. The time now is 06:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"