How to capitalize only first letter of a sentence

Question

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?

Answer 1

Something along the lines of the following. You didn't specify any details

= Table.AddColumn(Source, "Converted", each Text.Upper(Text.Middle([Column1],0,1))&Text.Middle([Column1],1,Text.Length([Column1])))

Answer 2

Try this, Excel style ;-)

let
    Input = "text to capitalize",
    Output = Text.Upper(Text.Start(Input,1)) & Text.End(Input,Text.Length(Input)-1)
in
    Output

Answer 3

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)