I have a column with 2 kind of words:
- words without uppercase (betrachtet) and
- words that begin with uppercase (Analysieren)
I need a filter that shows my only those words which begin with uppercase.
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 communityI have a column with 2 kind of words:
I need a filter that shows my only those words which begin with uppercase.
Using the =filter
function, you can try this :
=FILTER(A1:A15;REGEXMATCH(A1:A15;"[A-Z].*?"))
Note : Depending on your language settings, you can replace ;
with ,
=filter()
or the filter view ? Anyway, I think you need a regex – pjmg Oct 2 '19 at 7:50