Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
there are many ways and solutions:
=UPPER(LEFT(A1;1))&RIGHT(A1;LEN(A1)-1)
=REPLACE(A1;1;1;UPPER(LEFT(A1;1)))
If your word is on Colum A1 you can use this formula
=REPLACE(REPLACE(A1,1,1,UPPER(LEFT(A1,1)))
i agree with your answer mr ahmed alam
I think only good way is to copy text to word and change it using Shift + F3 command and then copy it back to the excel.