Change Uppercase Text to Lowercase Text in Excel

Edited by Djinu, VisiHow, Eng

You're watching VisiHow. In this video, we're going to show how to take all capital letters and turn them into lowercase letters using Microsoft Excel.

Change uppercase to lowercase in Excel.mp4-canvas17 230383.jpg

Ad

Steps

  1. 1
    Click cell "B2"
    .
    Change uppercase to lowercase in Excel.mp4-canvas8 563.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help
  2. 2
    Then, type an "=lower(A1)"
    .
    Alternatively, you can click the "A1" cell instead of typing "A1" in the formula.
    Change uppercase to lowercase in Excel.mp4-canvas15 764.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help
  3. 3
    Press "Enter"
    .
    Now, you will have the text in lowercase.
    Change uppercase to lowercase in Excel.mp4-canvas21 483999.jpg
    Was this step helpful? Yes | No | I need help
    Advertisement

That was how to change from uppercase letters to lowercase letters using Microsoft Excel. If you have any questions or comments, please leave them in the space below. Thanks for watching VisiHow!

Video: Change Uppercase Text to Lowercase Text in Excel

Referencing this Article

If you need to reference this article in your work, you can copy-paste the following depending on your required format:

APA (American Psychological Association)
Change Uppercase Text to Lowercase Text in Excel. (2016). In VisiHow. Retrieved Jun 22, 2017, from http://visihow.com/Change_Uppercase_Text_to_Lowercase_Text_in_Excel

Was this helpful? Yes | No | I need help

MLA (Modern Language Association) "Change Uppercase Text to Lowercase Text in Excel." VisiHow, visihow.com/Change_Uppercase_Text_to_Lowercase_Text_in_Excel Accessed 22 Jun 2017.

Chicago / Turabian VisiHow.com. "Change Uppercase Text to Lowercase Text in Excel." Accessed Jun 22, 2017. http://visihow.com/Change_Uppercase_Text_to_Lowercase_Text_in_Excel.

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.

Article Info

Categories : Microsoft Suites

Recent edits by: VisiHow, Djinu

Share this Article:

Thanks to all authors for creating a page that has been read 159 times.

Do you have a question not answered in this article?
Click here to ask one of the writers of this article
x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No