How can i filter a column to show me all the cells containing the word "on" when i try to filter i still get results like canyon or ontario etc which i dont need.
How can i filter a column to show me all the cells containing the word "on" when i try to filter i still get results like canyon or ontario etc which i dont need.
Use custom filter | contains, and then put a space either side of "on".
Hope this helps.
Pete
Hi,
Hit the filter, scroll down to Text Filters and select the relevant option.
Regards
You could use a helper column then, with a formula like this:
=IF(ISNUMBER(SEARCH(" on ",D2)),"yes","no")
assuming your data is in column D, then copy down and apply filter to this column, looking for yes.
Hope this helps.
Pete
Use custom filter | contains, and then put a space either side of "on".
Tried that it didnt work.
Hi Mikey,
Use an Advanced Filter like shown in http://www.contextures.com/xladvfilter01.html#critast
Make the criteria range this ( ="= * on *" ) with spaces before and after the "on".
See the example where I've done your advanced filter ..
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thank you pete and marvin both of these solutions work for what i need.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks