Forum Discussion
gvg
9 years agoPost Prodigy
Checking if string is in upper case in Power Query
Hi all. This might sound strange, but I need to check if string is in upper case. Any tips? This would be quite handy when you deal with Excel financial reports that have total rows in upper case...
- 9 years ago
=string = Text.Upper(string)
If this results in true, then the string is in all upper case.
MarcelBeug
9 years agoCommunity Champion
=string = Text.Upper(string)
If this results in true, then the string is in all upper case.
gvg
9 years agoPost Prodigy
Yes, it works. Thanks!