ExcelBanter - Filter for a symbol

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Filter for a symbol (https://www.excelbanter.com/excel-discussion-misc-queries/223881-filter-symbol.html)

S. H. Drew

Filter for a symbol

I have a list of items and some of them contain the minus symbol (-). I want
to use auto filter to find only those items that contain the minus sign. But
when I select "contains", equals, and then type the minus sign in the
criteria field, it returns no values. How can I get this filter to work?

Gary''s Student

Filter for a symbol

Contains works with embedded - as text. For numerical -, use Less than 0
--
Gary''s Student - gsnu200837

"S. H. Drew" wrote:

I have a list of items and some of them contain the minus symbol (-). I want
to use auto filter to find only those items that contain the minus sign. But
when I select "contains", equals, and then type the minus sign in the
criteria field, it returns no values. How can I get this filter to work?

All times are GMT +1. The time now is 05:48 AM.