Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How many ways you can change case in Ms Excel ?

Microsoft Excel Computer Science MS Office Automation MS Office tools Microsoft Word
user-image
Question added by abdul khayyum bashir ahmed , Human Resources Administrator , Al Diwan Al Amiri
Date Posted: 2016/02/21
Upvote (1) Views (1) Followers (4) Answers (3) Report Question
Write an Answer
Register now or log in to answer.
Sunil Pandey
by Sunil Pandey , Auditor , MB Group

Generally, excel have three options, they are 1. Upper, 2. Lower and 3. Proper

Deleted user
by Deleted user

You can have following three cases in MS Excel:

  • LOWER (Formula = LOWER("Text" | Cell Reference) for converting any text to All Lower Case.
  • UPPER (Formula = UPPER("Text" | Cell Reference) for converting any text to All Upper Case.
  • PROPER (Formula = PROPER("Text" | Cell Reference) for converting any text to all Proper Case.

Muhammad Yuseef
by Muhammad Yuseef , IT Manager , Master Point Trading

check :

 

https://www.ablebits.com/office-addins-blog/2014/04/25/change-case-excel-uppercase-lowercase/

Write Your Answer
More Questions Like This