I am trying to identify when a cell’s text is entirely uppercase and am using the assumption that if the first three characters are uppercase, the rest will be too. In this case it’s a city name.
This should work and does on regex testers, but is not in Parabola.
^[A-Z\s\.]{3}
Looks if the first 3 or 2 (accounting for a space or period) letters are uppercase. I am then replacing those first three characters with a symbol so I can then filter by the symbol in the next step.