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.

 

Thanks.

  • =string = Text.Upper(string)

     

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

2 Replies

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion

    =string = Text.Upper(string)

     

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

    • gvg's avatar
      gvg
      Post Prodigy

      Yes, it works. Thanks!