How can I create a filter on Google sheets to filter only words that begin with uppercase?

Question

I have a column with 2 kind of words:

1. words without uppercase (betrachtet) and
2. words that begin with uppercase (Analysieren)

I need a filter that shows my only those words which begin with uppercase.

Answer 1

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 ,