Forum Discussion

gvg's avatar
gvg
Post Prodigy
9 years ago
Solved

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...
  • MarcelBeug's avatar
    9 years ago

    =string = Text.Upper(string)

     

    If this results in true, then the string is in all upper case.