How to change capital letters into small letters in excel?

- Newsfeed
- Find People
- More
- - Products By Bayt.com
    
    Bayt.com
    
    Shagheel
    
    Specialities
    
    Learning
    
    Companies
    
    Salaries
    
    People
    
    Blog
    
    Podcasts
- - العربية
- Use Our Mobile App
  
  Get contacted by recruiters directly with our newest chat feature!
  
  Download Now

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)

Upvote (0)

Downvote Reply () Report

Popular Searches

Management Jobs Sales Executive Jobs Engineers Jobs Accountant Jobs Manager 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)