The function FIRSTCASE() is designed to convert the first character in the text to upper case, e.g.
First Case converts only the first character in the text to uppercase, leaving all other letters unchanged.
FIRSTCASE() is similar to the function SENTENCECASE() , but differs in that only the first character in the entire text changes.
=FIRSTCASE(Text)
The FIRSTCASE() function is easy to use. All you have to do is enter any text into the formula and Excel will automatically convert it to a new case:
=FIRSTCASE("total amount with VAT: 1000$")
We will have the following result:
This example uses the following values:
You can use the FIRSTCASE() function by installing the free extension YouLibreCalc.xlam .
After that, this function will be available in all files that will be opened in Excel.