Check if string has upper letters

[didijaba]

HI, I would like to check in Power Query if strings in Column_1 contain non upper-case letter. Any ideas?

 

[ImkeF]

Because M is case sensitive, this formula in a custom column will tell you if the string in Column1 contains one of the uppercased letters in the curly-bracket-range:

Text.PositionOfAny([Column1], {"A".."Z"})=-1

So if none of the capital letters is found, Text.PositionOfAny returns -1.

You can add special characters like this: {"A".."Z", "Ü"}

 

[didijaba]

Thanks, great tip