Forum Discussion
gvg
Post Prodigy
Post ProdigyChecking 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
- MarcelBeug
Community Champion
=string = Text.Upper(string)
If this results in true, then the string is in all upper case.
gvgYes, it works. Thanks!