I have a text column in my worksheet that I would like to format to sentence case (first letter capitalized and the remaining letters lower case). How can I do this?
If column name is [Foo] then one way to achieve this by the following:
Concat(Upper(Left([Foo],1)), Mid([Foo], 2))
It essentially takes the first character from the string and converts it to uppercase and then concatenates with the a substring starting from 2nd index of the same string.
Note - By not supplying a length argument to Mid() it will return the entire remaining string after the starting position provided by the 2nd arg.