Communiquez avec les autres et partagez vos connaissances professionnelles

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

Suivre

How can you change small letters to capital letters in Excel/word with short keys?

user-image
Question ajoutée par Noufal Ali , Designer (2D & 3D) , SAUDI FAN INDUSTRIES
Date de publication: 2013/05/15
Mohammed Yaseen MBA  PMP®
par Mohammed Yaseen MBA PMP® , Project Controller , Hayat Communication (www.haytacommunications.com)

MS Excel Case Changes:

If you need to change the case of text, such as people and product names, noufal chakkinga thodi and mohammed yaseen, uppercase, or lowercase, you don’t have to do a lot of retyping. In most cases, Flash Fill can do the work for you.

Here’s a list of names in lower case in column A. But let’s change the names to proper case, with the first letter in each name capitalized.

in Coulum  noufal chakkinga thodi and  mohammed yaseen   to > Noufal Chakkinga Thodi and Mohammed Yaseen.

in the column next to your data, enter the first and last name in proper case, and press Enter.

short key : Ctrl+E  or  Data > Flash  Fill.

.: Columan =PROPER(A1)

 

MS word:

Simply Select Text which you want to change case Press (Upper to lower and Lower to Upper) ctrl+shift+A

For  reset text format : ctrl+shift+n

Ansab Khan
par Ansab Khan , Sr. Officer , Meezan Bank Limited

In word shift +F3 In excel, formula =upper, =Lower, =proper

ahmed المصري
par ahmed المصري , أخصائي مراجعة , طنطا

In word shift +F3 In excel, formula =upper

Mike Emerson Pasaron
par Mike Emerson Pasaron , Safety Officer , Arabian Petrochemical Co. (PETROKEMYA)

Word and excel = shift+f3, excel =Proper()

Reem Al Shamsi
par Reem Al Shamsi , Community Banking Specialist , National Bank of Abu Dhabi

shift+alt

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?