Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
try this
in autofilter click custom equals *en this is wildcard find topmost cell must be column head. -------------- dtencza wrote in message ... 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. |
#3
|
|||
|
|||
You are right. I didn't notice the "ends with" option in the AutoFilter, and
I was making this hard on myself by trying to do the same thing using the advanced Filter. Thank you very much. "R.VENKATARAMAN" wrote: try this in autofilter click custom equals *en this is wildcard find topmost cell must be column head. -------------- dtencza wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace path name in Excel cells containing hyperlink | Excel Discussion (Misc queries) | |||
display count/results of filtering Excel in status bar | Excel Discussion (Misc queries) | |||
where Can I find the download for excel viewer for windows me | Excel Discussion (Misc queries) | |||
Where can I find advanced info on Excel Charts? | Charts and Charting in Excel | |||
Duplicate records in Excel | Excel Discussion (Misc queries) |