ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Noufal Ali , Designer (2D & 3D) , SAUDI FAN INDUSTRIES
تاريخ النشر: 2013/05/15
Mohammed Yaseen MBA  PMP®
من قبل 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
من قبل Ansab Khan , Sr. Officer , Meezan Bank Limited

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

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

In word shift +F3 In excel, formula =upper

Mike Emerson Pasaron
من قبل Mike Emerson Pasaron , Safety Officer , Arabian Petrochemical Co. (PETROKEMYA)

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

Reem Al Shamsi
من قبل Reem Al Shamsi , Community Banking Specialist , National Bank of Abu Dhabi

shift+alt

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟