Return the text converted to sentence case

The text string converted to a Sentence Case.


 A
1MY Sentence in mixed CHARACTERS
2=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1)) = My sentence in mixed characters

Built-in Functions

LEFT - The first or left most characters in a text string.
LEN - The number of characters in a text string.
LOWER - The text string with all the characters converted to lowercase.
RIGHT - The last or right most characters in a text string.
UPPER - The text string with all the characters converted to uppercase.


© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top