How to change capital letters into small letters in excel?

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Next Question:
How can you change small letters to capital letters in Excel/word with short key...
Posted by:
Noufal Ali
15-May-2013

Microsoft Excel Computer Science Computer Skills

Question added by srujana nayini
Date Posted: 2016/01/07

Upvote (0) Views (1) Followers (0) Answers (1) Report Question

Write an Answer
Register now or log in to answer.

1 Answers

by Rashid Altaf , Logistics Manager , Bilfinger

=LOWER(data range)

=LOWER(E1)

Downvote Reply () Report

Popular Searches

Sales Executive Jobs Engineers Jobs Engineering Technicians Jobs Accountant Jobs Driver Jobs

Write Your Answer

More Questions Like This

How to change in small to capital letters and capital to small letters?
Top Answer: By using CAPS LOCK in typing board. See More

Answers (2)
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?
Top Answer: there are many ways and solutions: =UPPER(LEFT(A1;1))&RIGHT(A1;LEN(A1)-1) =REPLACE(A1;1;1;UPPER(L ... See More

Answers (4)
=average(RT189:RT) ,I want to ask ,is it correct..I mean can we write average in small letters instead of capital letters.?
Top Answer: Yes. Excel will Re-Format your inputs. See More

Answers (1)
Which three keys to change small letters into capital letters?
Top Answer: to capitalize a letter - Caps Lock - select the words to change case - Press shift + F3 until capital c ... See More

Answers (6)

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