اكسل

In Excel, we have three different functions (LOWER, UPPER, and PROPER) to convert a text into different cases.

But there is no option to convert a text into sentences case. Here is the formula which you can use:

=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))