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?

score 2 · Answer 1 · answered Oct 26 '18 at 12:11

2

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])))

answered Oct 26 '18 at 12:11

horseyride

7,301
2
6
17

More or less the same as Alexis' solution, though a bit more complex, still also a +1 – intrixius Oct 29 '18 at 13:03

score 2 · Answer 2 · answered Oct 26 '18 at 12:15

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

answered Oct 26 '18 at 12:15

Daniel Herce

51
3

More or less the same as Alexis' solution, so also +1 – intrixius Oct 29 '18 at 13:03

score 1 · Accepted Answer · answered Oct 26 '18 at 14:32

1

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)

answered Oct 26 '18 at 14:32

Alexis Olson

36,898
7
37
62

This seems (together with the similar answers) the best way. Though, it surprises me that it is not a "standard" function... – intrixius Oct 29 '18 at 13:01

How to capitalize only first letter of a sentence

3 Answers3