Regular Expression to find character (alone)

Hi, I want to search for a single character, i.e.

;

Some cells have that character and nothing else, and those are the ones I want to find. Trouble is that character also appears in some cells as part of text, and I don’t want to touch those.

So how can I find the instances of ; that are alone in a cell?

Thanks!

search for ^;$
with option [x]regular expression

1 Like

Awesome thanks! :slight_smile:

Hallo
without regular Expression but with option [x]match whole cell it should work with the single semicolon in search-field

1 Like