powerquerym

How to capitalize only first letter of a sentence

I know of the m function Text.Proper which capitalizes all words in a sentence. However, I want to know how I can capitalize only the first word of a sentence?

Solution

  • There are a couple of decent answers already, but here's another option that demonstrates a couple more functions:

    Text.Upper(Text.At([Text],0)) & Text.Range([Text], 1, Text.Length([Text]) - 1)