I'm trying to filter a column to show cells that contain
@ (as in an email address) but when I put
@ in the filter box it comes up with a blank.
An example spreadsheet here. Here is also a screenshot:
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
The characters you enter in the filter box are matched to the beginning of any word in the cell content. So, @ will match "a @ b" or "a @b", but not "a@b".
To filter based on a pattern that is not a beginning of a word, you can use a workaround with
REGEXMATCH, e.g., entering in another column:
and then filtering based on that column.
However, the presence of @ does not guarantee you have a valid email there. I recommend using the
ISEMAIL function for accurate filtering: create a column with
and then filter on TRUE value in that column.