Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

If you want to change small characters to capital characters in excel, which formula you will use if u want to change the first letter only?

user-image
Question ajoutée par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date de publication: 2015/03/10
Ahmed Maher allam
par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions

there are many ways and solutions:

 

=UPPER(LEFT(A1;1))&RIGHT(A1;LEN(A1)-1)

 

=REPLACE(A1;1;1;UPPER(LEFT(A1;1)))

Mohammed Shan
par Mohammed Shan , Sr Network engineer , ECC

If your word is on Colum A1 you can use this formula

=REPLACE(REPLACE(A1,1,1,UPPER(LEFT(A1,1)))

FITAH MOHAMED
par FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

i agree with your answer mr ahmed alam   

Syed Ali Zeeshan ACCA
par Syed Ali Zeeshan ACCA , Assistant Manager Accounts - Receivable , Maxim International (Pvt.) Limited

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.

More Questions Like This