Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Noufal Ali , Designer (2D & 3D) , SAUDI FAN INDUSTRIES
Date Posted: 2013/05/15
Mohammed Yaseen MBA  PMP®
by 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
by Ansab Khan , Sr. Officer , Meezan Bank Limited

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

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

In word shift +F3 In excel, formula =upper

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

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

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

shift+alt

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.