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.
Thanks.
=string = Text.Upper(string)
If this results in true, then the string is in all upper case.
2 Replies
- MarcelBeugCommunity Champion
=string = Text.Upper(string)
If this results in true, then the string is in all upper case.
- gvgPost Prodigy
Yes, it works. Thanks!